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 the 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 | A system privilege. |
| ADMIN_OPTION | VARCHAR2(3) | NO | Indicates whether the grant was with the ADMIN option. |