DBA_SYS_PRIVS

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

Related view:

• USER_SYS_PRIVS lists 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