select distinct privilege from dba_sys_privs : dba_sys_privs « System Tables Views « Oracle PL / SQL

1. Oracle PL / SQL
2. System Tables Views
3. dba_sys_privs

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.

   
  

Related examples in the same category