Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Select distinct privilege from dba_sys_privs

VARCHAR2(3) SQL> select distinct privilege   2  from dba_sys_privs   3  where rownum < 50   4  order by privilege; PRIVILEGE ---------------------------------------- ADVISOR ALTER SYSTEM ALTER USER ANALYZE ANY AUDIT ANY AUDIT SYSTEM BECOME USER CREATE JOB CREATE ROLE CREATE RULE CREATE TABLE PRIVILEGE ---------------------------------------- CREATE TYPE CREATE USER CREATE VIEW DROP USER RESUMABLE 16 rows selected.