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 the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.