SYS.USER_SYS_PRIVS

The USER_SYS_PRIVS view lists the system privileges of the current user.

Related views

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

Columns

Column name Type Description

USERNAME

VARCHAR2(30) INLINE

User name

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.