Purpose
USER_SYS_PRIVS lists 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 | System privileges |
| ADMIN_OPTION | VARCHAR2(3) | NO | Indicates whether the grant was with the ADMIN option. |