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.
|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.|