Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Query dba_sys_privs table

SQL> SQL> set verify off SQL> SQL> column priv   format a30 heading "Privilege" SQL> column wadmin format a6 heading "Admin?" SQL> SQL> select privilege priv, initcap(admin_option) wadmin   2    from dba_sys_privs   3   where rownum < 50   4  / Privilege                      Admin? ------------------------------ ------ CREATE VIEW                    No ALTER SESSION                  No CREATE SESSION                 No CREATE SYNONYM                 No CREATE SEQUENCE                No CREATE DATABASE LINK           No UNLIMITED TABLESPACE           No ADVISOR                        Yes AUDIT ANY                      Yes DROP USER                      Yes RESUMABLE                      Yes ALTER USER                     Yes CREATE JOB                     Yes ANALYZE ANY                    Yes BECOME USER                    Yes CREATE ROLE                    Yes CREATE RULE                    Yes CREATE TYPE                    Yes CREATE USER                    Yes CREATE VIEW                    Yes ALTER SYSTEM                   Yes AUDIT SYSTEM                   Yes CREATE TABLE                   Yes DROP PROFILE                   Yes ALTER PROFILE                  Yes ALTER SESSION                  Yes DROP ANY ROLE                  Yes DROP ANY RULE                  Yes DROP ANY TYPE                  Yes DROP ANY VIEW                  Yes QUERY REWRITE                  Yes ALTER ANY ROLE                 Yes ALTER ANY RULE                 Yes ALTER ANY TYPE                 Yes ALTER DATABASE                 Yes CREATE ANY JOB                 Yes CREATE CLUSTER                 Yes CREATE LIBRARY                 Yes CREATE PROFILE                 Yes CREATE SESSION                 Yes CREATE SYNONYM                 Yes CREATE TRIGGER                 Yes DROP ANY INDEX                 Yes DROP ANY TABLE                 Yes GRANT ANY ROLE                 Yes LOCK ANY TABLE                 Yes MERGE ANY VIEW                 Yes UNDER ANY TYPE                 Yes UNDER ANY VIEW                 Yes 49 rows selected. SQL> SQL> --