Purpose
The USER_ROLE_PRIVS view displays the roles granted to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(30) | NO | The username of the user. |
| GRANTED_ROLE | VARCHAR2(30) | NO | The name of the role granted to the user. |
| 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. |