DBA_ROLE_PRIVS lists every role granted to every user in the database. Each row represents one role-to-user grant.
Columns
| Column | Type | Description |
|---|---|---|
grantee | TEXT | Username of the user who received the role grant. |
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. |