Oracle Database Administration: The Essential Refe

Optional Roles

The roles described in this section are created by executing one of the SQL scripts shipped with the database. They are documented here for completeness. Table 15.7 shows which scripts create which roles.

AQ_ADMINISTRATOR_ROLE

Used by the Advanced Queueing mechanism. Allows you to create and maintain queue tables.

AQ_USER_ROLE

Used by the Advanced Queueing mechanism. Allows you to send and retrieve queued messages.

EXP_FULL_DATABASE

Allows you to perform a full export. This role is explicitly looked for by the EXP (Export) utility when you perform a full export. Having all the system privileges is not sufficient to perform a full export.

HS_ADMIN_ROLE

Allows you to manage Heterogeneous Services.

IMP_FULL_DATABASE

Allows you to perform an import from a full export. This role is explicitly looked for by the IMP (Import) utility when you import from a full export. Having all the system privileges is not sufficient to create any object.

PLUSTRACE

Provides sufficient privileges to execute the SQL*Plus SET AUTOTRACE command.

RECOVERY_CATALOG_OWNER

Defines the owner of the recovery catalog to RMAN.

SNMPAGENT

Used in support of the SNMP intelligent agent within Oracle Enterprise Manager.

TKPROFER

Provides sufficient privileges to run TKPROF.

Table 15-7. Location of Scripts to Create Initial Roles

Role	Script Location
AQ_ADMINISTRATOR_ROLE	$ORACLE_HOME/rdbms/admin/dbmsaqad.sql
AQ_USER_ROLE	$ORACLE_HOME/rdbms/admin/dbmsaqad.sql
EXP_FULL_DATABASE	$ORACLE_HOME/rdbms/admin/catexp.sql ...