Feature
DBA_ROLE_PRIVS displays the roles granted to all users and the roles in the database.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
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. |