O'Reilly logo

Oracle Database Administration: The Essential Refe by Brian Laskey, David C. Kreines

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required