USER_SYS_PRIVS

USER_SYS_PRIVS describes system privileges granted to the current user.

Column Datatype NULL Description
USERNAME VARCHAR2(30)   Name of the user, or PUBLIC
PRIVILEGE VARCHAR2(40) NOT NULL System privilege
ADMIN_OPTION VARCHAR2(3)   Indicates whether the grant was with the ADMIN option (YES) or not (NO)