Purpose
The DBA_ROLE_PRIVS view 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 the MySQL mode.
Related views
USER_ROLE_PRIVS
Columns
Column |
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. |