Purpose
The DBA_SYS_PRIVS view displays the system privileges granted to users and roles. This view does not display the USERNAME column.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only the MySQL mode.
Related views
USER_SYS_PRIVS
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(128) | NO | The name, user, or role of the grantee 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. |