Purpose
DBA_ROLE_PRIVS displays the roles granted to all users and the roles in the database.
Related views
USER_ROLE_PRIVS
Fields
| Field | Type | Nullable? | Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(30) | NO | The username of the user or role receiving the grant. |
| GRANTED_ROLE | VARCHAR2(30) | NO | The granted role name. |
| ADMIN_OPTION | VARCHAR2(3) | NO | Indicates whether the grant was with the ADMIN option. |
| DEFAULT_ROLE | VARCHAR2(3) | NO | Indicates whether the role is designated as a default role for the user. |