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