O'Reilly logo

Oracle Built-in Packages by John Beresniewicz, Charles Dye, Steven Feuerstein

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

DBMS_REPCAT_ADMIN: Setting Up More Administrator Accounts

Along with DBMS_REPCAT_AUTH, use the DBMS_REPCAT_ADMIN package to create administrator accounts for replication. This section explains how to do so.

Getting Started with DBMS_REPCAT_ADMIN

The DBMS_REPCAT_ADMIN package is created when the Oracle database is installed. The dbmsrepc.sql script (found in the built-in packages source directory, as described in Chapter 1) contains the source code for this package’s specification. This script is called by catrep.sql, which must be run to install the advanced replication packages. The wrapped sql script prvtrepc.sql creates the public synonym DBMS_REPCAT_ADMIN. No EXECUTE privileges are granted on DBMS_REPCAT_ADMIN; only the owner (SYS) and those with the EXECUTE ANY PROCEDURE system privilege may execute the package.

DBMS_REPCAT_ADMIN programs

Table 15.2 lists the programs in DBMS_REPCAT_ADMIN

Table 15-2. DBMS_REPCAT_ADMIN Program

Name

Description

Use in SQL?

GRANT_ADMIN_ANY_REPGROUP

Grants privileges required to administer any replication group at the current site

No

GRANT_ADMIN_ANY_REPSCHEMA

(Oracle8)

Grants privileges required to administer any replication schema at the current site

No

GRANT_ADMIN_REPGROUP

Grants privileges required to administer the replication group for which the user is the schema owner

No

GRANT_ADMIN_REPSCHEMA

(Oracle8)

Grants privileges required to administer the replication schema for which the user is the schema owner

No

REVOKE_ADMIN_ANY_REPGROUP ...

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