SQL>
SQL> SELECT b.privilege what_granted,
2 b.admin_option, a.username
3 FROM sys.dba_users a, sys.dba_sys_privs b
4 WHERE a.username = b.grantee
5 and rownum< 50
6 ORDER BY 1,2;
WHAT_GRANTED ADM USERNAME
---------------------------------------- --- ------------------------------
ALTER ANY EVALUATION CONTEXT YES SYS
ALTER ANY RULE SET YES SYS
ALTER DATABASE NO FLOWS_020100
ALTER SESSION NO XDB
ALTER SESSION NO FLOWS_020100
ALTER SESSION NO HR
ALTER SYSTEM NO FLOWS_020100
ANALYZE ANY NO SYS
CREATE ANY CONTEXT YES FLOWS_020100
CREATE ANY DIRECTORY NO FLOWS_020100
CREATE ANY EVALUATION CONTEXT YES SYS
WHAT_GRANTED ADM USERNAME
---------------------------------------- --- ------------------------------
CREATE ANY RULE SET YES SYS
CREATE ANY SYNONYM NO FLOWS_FILES
CREATE CLUSTER YES FLOWS_020100
CREATE DATABASE LINK NO HR
CREATE DIMENSION YES FLOWS_020100
CREATE INDEXTYPE YES FLOWS_020100
CREATE LIBRARY NO MDSYS
CREATE MATERIALIZED VIEW NO SYSTEM
CREATE MATERIALIZED VIEW YES FLOWS_020100
CREATE PUBLIC SYNONYM NO MDSYS
CREATE ROLE NO FLOWS_020100
WHAT_GRANTED ADM USERNAME
---------------------------------------- --- ------------------------------
CREATE RULE YES SYS
CREATE RULE SET YES SYS
CREATE SEQUENCE NO HR
CREATE SESSION NO MDSYS
CREATE SESSION NO XDB
CREATE SESSION NO DIP
CREATE SESSION NO RNTSOFT
CREATE SESSION NO OUTLN
CREATE SYNONYM NO HR
CREATE TABLE NO MDSYS
CREATE TABLE YES FLOWS_020100
WHAT_GRANTED ADM USERNAME
---------------------------------------- --- ------------------------------
DEQUEUE ANY QUEUE YES SYS
DROP ANY RULE SET YES SYS
ENQUEUE ANY QUEUE YES SYS
EXECUTE ANY PROCEDURE NO FLOWS_020100
EXECUTE ANY RULE SET YES SYS
EXECUTE ANY TYPE NO SYS
LOCK ANY TABLE NO SYS
MANAGE ANY QUEUE YES SYS
SELECT ANY TABLE YES SYS
UNLIMITED TABLESPACE NO DBSNMP
UNLIMITED TABLESPACE NO XDB
WHAT_GRANTED ADM USERNAME
---------------------------------------- --- ------------------------------
UNLIMITED TABLESPACE NO FLOWS_FILES
UNLIMITED TABLESPACE NO PLSQL
UNLIMITED TABLESPACE NO OUTLN
UNLIMITED TABLESPACE NO MDSYS
UPDATE ANY TABLE NO SYS
49 rows selected.
SQL>