Checking System Privileges Granted to a User: user_sys_privs : user_sys_privs « System Tables Data Dictionary « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. System Tables Data Dictionary
3. 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>