Query dba_sys_privs table : dba_sys_privs « System Tables Views « Oracle PL / SQL






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> --

   
  








Related examples in the same category

1.select distinct privilege from dba_sys_privs
2.User System Privileges