DBA_ROLE_PRIVS v17
The DBA_ROLE_PRIVS view provides information on all roles that were granted to users. A row is created for each role to which a user was granted.
| Name | Type | Description |
|---|---|---|
grantee | TEXT | User name to whom the role was granted. |
granted_role | TEXT | Name of the role granted to the grantee. |
admin_option | TEXT | YES if the role was granted with the admin option. NO otherwise. |
default_role | TEXT | YES if the role is enabled when the grantee creates a session. |