Skip Headers

Oracle® Database Advanced Replication Management API Reference
10g Release 1 (10.1)

Part Number B10733-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page
Previous
Go to next page
Next
View PDF

19
DBMS_REPCAT_ADMIN

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

This chapter contains this topic:

Summary of DBMS_REPCAT_ADMIN Subprograms

Table 19-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.