DBA_SYS_PRIVS

DBA_SYS_PRIVS describes system privileges granted to users and roles. This view does not display the USERNAME column.

Related View

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