SYS.DBA_SYS

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 name Type Description.

Column name	Type	Description.
`GRANTEE`	`VARCHAR2(30) INLINE`	Name of the user with the privilege
`PRIVILEGE`	`VARCHAR2(40) INLINE NOT NULL`	Privilege name
`ADMIN_OPTION`	`VARCHAR2(3) INLINE NOT NULL`	`YES` if user can grant the privilege; `NO` if not The value is `YES` only for the `ADMIN` privilege.

GRANTEE

VARCHAR2(30) INLINE

Name of the user with the privilege

PRIVILEGE

VARCHAR2(40) INLINE NOT NULL

Privilege name

ADMIN_OPTION

VARCHAR2(3) INLINE NOT NULL

YES if user can grant the privilege; NO if not

The value is YES only for the ADMIN privilege.

SYS.DBA_SYS_PRIVS