SYS.DBA_SYS_PRIVS

The DBA_SYS_PRIVS view lists the system privileges granted to all users and to PUBLIC.

Required privileges

ADMIN

Related views

SYS.USER_SYS_PRIVS lists system privileges granted to the current user.

Columns

Column	Type	Description.
GRANTEE	VARCHAR2(30) NOT NULL	Name of the user with the privilege
PRIVILEGE	VARCHAR2(40) NOT NULL	Privilege name
ADMIN OPTION	VARCHAR2(3) NOT NULL	Indicates whether the user can grant the privilege. Possible values are YES and NO. The value is YES only for the ADMIN privilege.