Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Oracle System Privilege Grants to Users

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>