Checking System Privileges Granted to a User

You can check which system privileges a user has by querying user_sys_privs.

Some Columns in user_sys_privs:

ColumnTypeDescription
usernameVARCHAR2(30)Name of the current user
privilegeVARCHAR2(40)The system privilege the user has
admin_optionVARCHAR2(3)Whether the user is able to grant the privilege to another user

user_sys_privs is part of the Oracle database's data dictionary. The data dictionary stores information about the database itself.


SQL> SELECT *
  2  FROM user_sys_privs
  3  ORDER BY privilege;

USERNAME                       PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
SYS                            ALTER ANY EVALUATION CONTEXT             YES
SYS                            ALTER ANY RULE                           YES
SYS                            ALTER ANY RULE SET                       YES
SYS                            ANALYZE ANY                              NO
SYS                            CREATE ANY EVALUATION CONTEXT            YES
SYS                            CREATE ANY RULE                          YES
SYS                            CREATE ANY RULE SET                      YES
SYS                            CREATE EVALUATION CONTEXT                YES
SYS                            CREATE RULE                              YES
SYS                            CREATE RULE SET                          YES
SYS                            DELETE ANY TABLE                         NO

USERNAME                       PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
SYS                            DEQUEUE ANY QUEUE                        YES
SYS                            DROP ANY EVALUATION CONTEXT              YES
SYS                            DROP ANY RULE                            YES
SYS                            DROP ANY RULE SET                        YES
SYS                            ENQUEUE ANY QUEUE                        YES
SYS                            EXECUTE ANY EVALUATION CONTEXT           YES
SYS                            EXECUTE ANY PROCEDURE                    NO
SYS                            EXECUTE ANY RULE                         YES
SYS                            EXECUTE ANY RULE SET                     YES
SYS                            EXECUTE ANY TYPE                         NO
SYS                            INSERT ANY TABLE                         NO

USERNAME                       PRIVILEGE                                ADM
------------------------------ ---------------------------------------- ---
SYS                            LOCK ANY TABLE                           NO
SYS                            MANAGE ANY QUEUE                         YES
SYS                            SELECT ANY SEQUENCE                      NO
SYS                            SELECT ANY TABLE                         YES
SYS                            UPDATE ANY TABLE                         NO

27 rows selected.

SQL>
Home »
Oracle »
User, Privilege, Role » 

System Privileges:
  1. System Privileges
  2. Use WITH ADMIN OPTION
  3. Checking System Privileges Granted to a User
  4. Revoking System Privileges from a User
Related: