Oracle System Privilege Grants to Users : dba_sys_privs « System Tables Data Dictionary « Oracle PL/SQL Tutorial






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








30.40.dba_sys_privs
30.40.1.Oracle System Privilege Grants to Users
30.40.2.Oracle System Privilege Grants to Roles
30.40.3.User System Privileges