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

Home
Oracle PL/SQL Tutorial
1.Introduction
2.Query Select
3.Set
4.Insert Update Delete
5.Sequences
6.Table
7.Table Joins
8.View
9.Index
10.SQL Data Types
11.Character String Functions
12.Aggregate Functions
13.Date Timestamp Functions
14.Numerical Math Functions
15.Conversion Functions
16.Analytical Functions
17.Miscellaneous Functions
18.Regular Expressions Functions
19.Statistical Functions
20.Linear Regression Functions
21.PL SQL Data Types
22.PL SQL Statements
23.PL SQL Operators
24.PL SQL Programming
25.Cursor
26.Collections
27.Function Procedure Packages
28.Trigger
29.SQL PLUS Session Environment
30.System Tables Data Dictionary
31.System Packages
32.Object Oriented
33.XML
34.Large Objects
35.Transaction
36.User Privilege
Oracle PL/SQL Tutorial » System Tables Data Dictionary » dba_sys_privs 
30.40.1.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  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
java2s.com  | Contact Us | Privacy Policy
Copyright 2009 - 12 Demo Source and Support. All rights reserved.
All other trademarks are property of their respective owners.