21
DBMS_REPCAT_ADMIN

DBMS_REPCAT_ADMIN enables you to create users with the privileges needed by the symmetric replication facility.

This chapter discusses the following topics:

• Summary of DBMS_REPCAT_ADMIN Subprograms

Summary of DBMS_REPCAT_ADMIN Subprograms

Table 21-1 DBMS_REPCAT_ADMIN Package Subprograms

Subprogram	Description
GRANT_ADMIN_ANY_SCHEMA Procedure	Grants the necessary privileges to the replication administrator to administer any replication group at the current site.
GRANT_ADMIN_SCHEMA Procedure	Grants the necessary privileges to the replication administrator to administer a schema at the current site.
REGISTER_USER_REPGROUP Procedure	Assigns proxy materialized view administrator or receiver privileges at the master site or master materialized view site for use with remote sites.
REVOKE_ADMIN_ANY_SCHEMA Procedure	Revokes the privileges and roles from the replication administrator that were granted by GRANT_ADMIN_ANY_SCHEMA.
REVOKE_ADMIN_SCHEMA Procedure	Revokes the privileges and roles from the replication administrator that were granted by GRANT_ADMIN_SCHEMA.
UNREGISTER_USER_REPGROUP Procedure	Revokes the privileges and roles from the proxy materialized view administrator or receiver that were granted by the REGISTER_USER_REPGROUP procedure.