Purpose
Describes the roles granted to the current user.
Applicability
This view is available starting with OceanBase Database in Oracle mode.
Columns
Column |
Type |
Nullable |
Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(30) | NO | The name of the user, or PUBLIC |
| GRANTED_ROLE | VARCHAR2(30) | NO | The name of the role granted to the user |
| ADMIN_OPTION | VARCHAR2(3) | NO | Indicates whether the ADMIN option was used during the grant. |
| DEFAULT_ROLE | VARCHAR2(3) | NO | Indicates whether the role is specified as the DEFAULT ROLE of the user. |
Sample query
Query the roles granted to the current user.
obclient [SYS]> SELECT * FROM USER_ROLE_PRIVS;
The query result is as follows:
+---------+--------------+--------------+--------------+
| GRANTEE | GRANTED_ROLE | ADMIN_OPTION | DEFAULT_ROLE |
+---------+--------------+--------------+--------------+
| SYS | ROLE1 | YES | YES |
| SYS | ROLE2 | YES | YES |
+---------+--------------+--------------+--------------+
2 rows in set