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: