Oracle PL/SQL Tutorial/System Tables Data Dictionary/user sys privs

30. Checking System Privileges Granted to a User: user_sys_privs

SQL>
SQL>
SQL> desc user_sys_privs;
 Name            Null?    Type
------------------------------
 USERNAME                 VARCHAR2(30)    --Name of the current user.
 PRIVILEGE       NOT NULL VARCHAR2(40)    --System privilege. 
 ADMIN_OPTION             VARCHAR2(3)     --Whether the user is able to grant the privilege to another user.

SQL>
SQL> SELECT * FROM user_sys_privs;
SQL>
SQL>