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.
Used by the Advanced Queueing mechanism. Allows you to create and maintain queue tables.
Used by the Advanced Queueing mechanism. Allows you to send and retrieve queued messages.
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.
Allows you to manage Heterogeneous Services.
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.
Provides sufficient privileges to execute the SQL*Plus SET AUTOTRACE command.
Defines the owner of the recovery catalog to RMAN.
Used in support of the SNMP intelligent agent within Oracle Enterprise Manager.
Provides sufficient privileges to run TKPROF.
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 |
HS_ADMIN_ROLE |
$ORACLE_HOME/rdbsm/admin/caths.sql |
IMP_FULL_DATABASE |
$ORACLE_HOME/rdbms/admin/catexp.sql |
PLUSTRACE |
$ORACLE_HOME/plus80/plustrce.sql |
SNMPAGENT |
$ORACLE_HOME/rdbms/admin/catsnmp.sql |
RECOVERY_CATALOG_OWNER |
$ORACLE_HOME/rdbms/admin/catalog.sql |
TKPROFER |
$ORACLE_HOME/rdbms/admin/utltkprf.sql |