The USER_ROLE_PRIVS view provides the information about the permissions that have been granted to the current user. A row is created for each role to which a user has been granted.

Parameter Type Description
username TEXT The name of the user to which the role was granted.
granted_role TEXT The name of the role granted to the grantee.
admin_option TEXT YES: The role is granted with the admin option. NO: The role is granted with the other options other than admin.
default_role TEXT YES: The role is enabled when the grantee creates a session.
os_granted CHARACTER VARYING(3) This parameter is supported for compatibility only. The value is NO.