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