Purpose
DBA_SYS_PRIVS displays the system privileges granted to users and roles. This view does not display the USERNAME column.
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. |