Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Checking System Privileges Granted to a User

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>