Cross-Reference: Roles and System Privileges

Table 15.8 shows which Oracle system privileges are assigned to the initial roles described in the preceding sections.

Table 15-8. Cross-Reference Listing of System Privileges and Roles
 

Role

      

System Privilege

CONNECT

DBA

EXP_FULL_ DATABASE

IMP_FULL_ DATABASE

RECOVERY_ CATALOG_ OWNER

RESOURCE

SNMPAGENT

ALTER ANY CLUSTER

 

image with no caption

     

ALTER ANY INDEX

 

image with no caption

     

ALTER ANY LIBRARY

 

image with no caption

     

ALTER ANY PROCEDURE

 

image with no caption

     

ALTER ANY ROLE

 

image with no caption

     

ALTER ANY SEQUENCE

 

image with no caption

     

ALTER ANY SNAPSHOT

 

image with no caption

     

ALTER ANY TABLE

 

image with no caption

 

image with no caption

   

ALTER ANY ...

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.