Purpose
The USER_SYS_PRIVS view displays system privileges granted to the current user.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
Related views
DBA_SYS_PRIVS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(128) | NO | The name of the grantee, user, or role who received the grant. |
| PRIVILEGE | VARCHAR2(40) | NO | The system privilege. |
| ADMIN_OPTION | VARCHAR2(3) | NO | Indicates whether the grant was with the ADMIN option. |