USER_ROLE_PRIVS v11

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

NameTypeDescription
usernameTEXTThe name of the user to which the role was granted.
granted_roleTEXTName of the role granted to the grantee.
admin_optionTEXTYES if the role was granted with the admin option, NO otherwise.
default_roleTEXTYES if the role is enabled when the grantee creates a session.
os_grantedCHARACTER VARYING(3)Included for compatibility only; always NO.