PL/SQL Packages DBMS_REPCAT_ADMIN

Record the name of an executing module (or transaction) in the database for later use with Oracle Trace and the SQL trace facility.

Subprocedures:

GRANT_ADMIN_ANY_SCHEMA   Grant the necessary privileges to the replication administrator
                         to administer any replication group at the current site.  

GRANT_ADMIN_SCHEMA       Grant the necessary privileges to the replication administrator
                         to administer a schema at the current site.  

REGISTER_USER_REPGROUP   Assign 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  Revoke the privileges and roles from the replication administrator
                         that were granted by GRANT_ADMIN_ANY_SCHEMA. 

REVOKE_ADMIN_SCHEMA      Revoke the privileges and roles from the replication administrator
                         that were granted by GRANT_ADMIN_SCHEMA. 

UNREGISTER_USER_REPGROUP Revoke the privileges and roles from the proxy materialized
                         view administrator or receiver that were granted by the
                         REGISTER_USER_REPGROUP procedure.  

For full documentation of the packaged procedures above see the Oracle Manual:
"Oracle9i Supplied PL/SQL Packages and Types Reference"

or the book Oracle Built in Packages by Steven Feuerstein et al

Related: 


© Copyright SS64.com 1999-2013
Some rights reserved