Purpose
The ROLE_ROLE_PRIVS view displays roles granted to other roles. Information is provided only about roles to which the user has access.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| ROLE | VARCHAR2(128) | NO | The name of the role. |
| GRANTED_ROLE | VARCHAR2(128) | NO | The granted role. |
| ADMIN_OPTION | VARCHAR2(3) | NO | Indicates whether the role was granted with the ADMIN option. |