DBMS_REPCAT_ADMIN: Setting Up Administrative Accounts
The first step in creating an advanced replication environment is to create administrative and end user accounts. The DBMS_REPCAT_AUTH and DBMS_REPCAT_ADMIN packages contain programs that grant and revoke the privileges required in such an environment.
How the Package Is Used
The replication administration account or a DBA account uses the procedures in DBMS_REPCAT_ADMIN to grant or revoke the specified privileges.
Installation and Access
The DBMS_REPCAT_ADMIN package iscreated when the Oracle database is installed. The
dbmsrepc.sql
script (found in the built-in packages source
directory) 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 Procedures
Note
Oracle8 documents only the REPGROUP procedures listed here, although the REPSCHEMA procedures also exist. The functionality is identical.
Procedure Name | Description |
---|---|
GRANT_ADMIN_ANY_REPGROUP (Oracle8) | Grants privileges required to administer any replication group at the current site |
GRANT_ADMIN_ANY_REPSCHEMA | Grants privileges required to administer any replication schema at the current site |
GRANT_ADMIN_REPGROUP (Oracle8) | Grants ... |
Get Oracle Distributed Systems 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.