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

 

   

ALTER ANY SEQUENCE

Get Oracle Database Administration: The Essential Refe now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.