Feature
DBA_SYS_PRIVS 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 MySQL mode.
Related views
USER_SYS_PRIVS
Fields
| Field | Type | Nullable | Description |
|---|---|---|---|
| GRANTEE | VARCHAR2(128) | NO | The name, user, or role of the grantee 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. |