Cross-Reference: System Privileges Assigned to Initial Users

Table 15.10 shows the system privileges assigned to the initial users. Note that since the SYS and SYSTEM users are granted the DBA role by default, they actually acquire all the privileges granted through that role.

Table 15-10. Cross-Reference Listing of System Privileges and Users
 

Granted to

     

Privilege Assigned

CTXSYS

DBSNMP

MDSYS

ORDSYS

SYS

SYSTEM

ALTER ANY CLUSTER

image with no caption

 

image with no caption

   

ALTER ANY INDEX

image with no caption

 

image with no caption

   

ALTER ANY LIBRARY

image with no caption

 

image with no caption

   

ALTER ANY PROCEDURE

image with no caption

 

image with no caption

   

ALTER ANY ROLE

image with no caption

 

image with no caption

   

ALTER ANY SEQUENCE

image with no caption

 

image with no caption

   

ALTER ANY SNAPSHOT

image with no caption

 

image with no caption

   

ALTER ANY TABLE

image with no caption

 

image with no caption

   

ALTER ANY TRIGGER

image with no caption

 

image with no caption

   

ALTER ANY TYPE

image with no caption

 

image with no caption

   

ALTER DATABASE

image with no caption

 

image with no caption

   

ALTER PROFILE

image with no caption

 

image with no caption

   

ALTER RESOURCE COST

image with no caption

 

image with no caption

   

ALTER ROLLBACK SEGMENT

image with no caption

 

image with no caption

   

ALTER SESSION

image with no caption

 

image with no caption

   

ALTER SYSTEM

image with no caption

 

image with no caption

   

ALTER TABLESPACE

image with no caption

 

image with no caption

   

ALTER USER

image with no caption

 

image with no caption

   

ANALYZE ANY

image with no caption

 

image with no caption

   

AUDIT ANY

image with no caption

 

image with no caption

   

AUDIT SYSTEM

image with no caption

 

image with no caption

   

BACKUP ANY TABLE

image with no caption

 

image with no caption

   

BECOME USER

image with no caption

 

image with no caption

   

COMMENT ANY TABLE

image with no caption

 

image with no caption

   

CREATE ANY CLUSTER

image with no caption

 

image with no caption

   

CREATE ANY DIRECTORY

image with no caption

 

image with no caption

   

CREATE ANY INDEX

image with no caption

 

image with no caption

   

CREATE ANY LIBRARY

image with no caption

 

image with no caption

   

CREATE ANY PROCEDURE

image with no caption

 

image with no caption

   

CREATE ANY SEQUENCE

image with no caption

 

image with no caption

   

CREATE ANY SNAPSHOT

image with no caption

 

image with no caption

   

CREATE ANY SYNONYM

image with no caption

 

image with no caption

   

CREATE ANY TABLE

image with no caption

 

image with no caption

image with no caption

  

CREATE ANY TRIGGER

image with no caption

 

image with no caption

   

CREATE ANY TYPE

image with no caption

 

image with no caption

image with no caption

  

CREATE ANY VIEW

image with no caption

 

image with no caption

   

CREATE CLUSTER

image with no caption

 

image with no caption

   

CREATE DATABASE LINK

image with no caption

 

image with no caption

   

CREATE LIBRARY

image with no caption

 

image with no caption

image with no caption

  

CREATE PROCEDURE

image with no caption

 

image with no caption

image with no caption

  

CREATE PROFILE

image with no caption

 

image with no caption

   

CREATE PUBLIC DATABASE LINK

image with no caption

 

image with no caption

   

CREATE PUBLIC SYNONYM

image with no caption

image with no caption

image with no caption

image with no caption

  

CREATE ROLE

image with no caption

 

image with no caption

   

CREATE ROLLBACK SEGMENT

image with no caption

 

image with no caption

   

CREATE SEQUENCE

image with no caption

 

image with no caption

   

CREATE SESSION

image with no caption

 

image with no caption

image with no caption

  

CREATE SNAPSHOT

image with no caption

 

image with no caption

   

CREATE SYNONYM

image with no caption

 

image with no caption

   

CREATE TABLE

image with no caption

 

image with no caption

   

CREATE TABLESPACE

image with no caption

 

image with no caption

   

CREATE TRIGGER

image with no caption

 

image with no caption

   

CREATE TYPE

image with no caption

 

image with no caption

   

CREATE USER

image with no caption

 

image with no caption

   

CREATE VIEW

image with no caption

 

image with no caption

   

DELETE ANY TABLE

image with no caption

 

image with no caption

 

image with no caption

 

DROP ANY CLUSTER

image with no caption

 

image with no caption

   

DROP ANY DIRECTORY

image with no caption

 

image with no caption

   

DROP ANY INDEX

image with no caption

 

image with no caption

   

DROP ANY LIBRARY

image with no caption

 

image with no caption

   

DROP ANY PROCEDURE

image with no caption

 

image with no caption

   

DROP ANY ROLE

image with no caption

 

image with no caption

   

DROP ANY SEQUENCE

image with no caption

 

image with no caption

   

DROP ANY SNAPSHOT

image with no caption

 

image with no caption

   

DROP ANY SYNONYM

image with no caption

 

image with no caption

   

DROP ANY TABLE

image with no caption

 

image with no caption

   

DROP ANY TRIGGER

image with no caption

 

image with no caption

   

DROP ANY TYPE

image with no caption

 

image with no caption

image with no caption

  

DROP ANY VIEW

image with no caption

 

image with no caption

   

DROP PROFILE

image with no caption

 

image with no caption

   

DROP PUBLIC DATABASE LINK

image with no caption

 

image with no caption

   

DROP PUBLIC SYNONYM

image with no caption

 

image with no caption

image with no caption

  

DROP ROLLBACK SEGMENT

image with no caption

 

image with no caption

   

DROP TABLESPACE

image with no caption

 

image with no caption

   

DROP USER

image with no caption

 

image with no caption

   

EXECUTE ANY LIBRARY

image with no caption

 

image with no caption

   

EXECUTE ANY PROCEDURE

image with no caption

 

image with no caption

 

image with no caption

 

EXECUTE ANY TYPE

image with no caption

 

image with no caption

 

image with no caption

 

FORCE ANY TRANSACTION

image with no caption

 

image with no caption

   

FORCE TRANSACTION

image with no caption

 

image with no caption

   

GRANT ANY PRIVILEGE

image with no caption

 

image with no caption

   

GRANT ANY ROLE

image with no caption

 

image with no caption

   

INSERT ANY TABLE

image with no caption

 

image with no caption

   

LOCK ANY TABLE

image with no caption

 

image with no caption

 

image with no caption

 

MANAGE TABLESPACE

image with no caption

 

image with no caption

   

RESTRICTED SESSION

image with no caption

 

image with no caption

   

SELECT ANY SEQUENCE

image with no caption

 

image with no caption

   

SELECT ANY TABLE

image with no caption

 

image with no caption

 

image with no caption

 

UNLIMITED TABLESPACE

image with no caption

 

image with no caption

 

image with no caption

 

UPDATE ANY TABLE

image with no caption

image with no caption

image with no caption

image with no caption

 

image with no caption

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset