DBA_SYS_PRIVS describes system privileges granted to users and roles. This view does not display the USERNAME column.
USER_SYS_PRIVS describes system privileges granted to the current user. This view does not display the GRANTEE column, but instead displays the USERNAME column.
| Column | Datatype | NULL | Description |
|---|---|---|---|
GRANTEE |
VARCHAR2(30) |
NOT NULL |
Grantee name, user, or role receiving the grant |
USERNAME |
VARCHAR2(30) |
Name of the current user | |
PRIVILEGE |
VARCHAR2(40) |
NOT NULL |
System privilege |
ADMIN_OPTION |
VARCHAR2(3) |
Grant was with the ADMIN option |