Oracle8i Supplied Packages Reference
Release 8.1.5
A68001-01

Library
Product
Contents
Index

Prev Next

35
DBMS_REPCAT_ADMIN

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

Summary of Subprograms

Table 35-1 DBMS_REPCAT_ADMIN Package Subprograms
Subprogram  Description  
GRANT_ADMIN_ANY_SCHEMA 
procedure
 

Grants the necessary privileges to the replication administrator to administer any replicated object 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 snapshot administrator or receiver privileges at the master site for use with remote sites.  

 
REVOKE_ADMIN_ANY_SCHEMA 
procedure
 

Revokes the privileges and roles from the replication administrator that would be granted by GRANT_ADMIN_ANY_SCHEMA.  

 
REVOKE_ADMIN_SCHEMA 
procedure
 

Revokes the privileges and roles from the replication administrator that would be granted by GRANT_ADMIN_SCHEMA.  

 
UNREGISTER_USER_REPGROUP 
procedure
 

Revokes the privileges and roles from the proxy snapshot administrator or receiver that would be granted by the REGISTER_USER_REPGROUP procedure.  

GRANT_ADMIN_ANY_SCHEMA procedure

This procedure grants the necessary privileges to the replication administrator to administer any replicated object group at the current site.

Syntax

DBMS_REPCAT_ADMIN.GRANT_ADMIN_ANY_SCHEMA (
   username  IN   VARCHAR2);

Parameters

Table 35-2 GRANT_ADMIN_ANY_SCHEMA Procedure Parameters
Parameter  Description  
username
 

Name of the replication administrator to whom you want to grant the necessary privileges and roles to administer any replicated object groups at the current site.  

Exceptions

Table 35-3 GRANT_ADMIN_ANY_REPGROUP Procedure Exceptions
Exception  Description  
ORA-01917
 

User does not exist.  

GRANT_ADMIN_SCHEMA procedure

This procedure grants the necessary privileges to the replication administrator to administer a schema at the current site. This procedure is most useful if your object group does not span schemas.

Syntax

DBMS_REPCAT_ADMIN.GRANT_ADMIN_SCHEMA (
   username IN VARCHAR2);

Parameters

Table 35-4 GRANT_ADMIN_REPSCHEMA Procedure Parameters
Parameter  Description  
username
 

Name of the replication administrator. This user is then granted the necessary privileges and roles to administer the schema of the same name within a replicated object group at the current site.  

Exceptions

Table 35-5 GRANT_ADMIN_REPSCHEMA Procedure Exceptions
Exception  Description  
ORA-01917
 

User does not exist.  

REGISTER_USER_REPGROUP procedure

This procedure assigns proxy snapshot administrator or receiver privileges at the master site for use with remote sites. This procedure grants only the necessary privileges to the proxy snapshot administrator or receiver, avoiding having to grant the powerful privileges granted by the GRANT_ADMIN_SCHEMA or GRANT_ADMIN_ANY_SCHEMA procedures.

See Also:

See "Advanced Techniques" in the Oracle8i Replication manual for more information on trusted versus untrusted security models.  

Syntax

DBMS_REPCAT_ADMIN.REGISTER_USER_REPGROUP (
   username         IN   VARCHAR2,
   privilege_type   IN   VARCHAR2,
   list_of_gnames   IN   VARCHAR2 |
   table_of_gnames  IN   dbms_utility.name_array);

Parameters

Table 35-6 REGISTER_USER_REPGROUP Procedure Parameters
Parameter  Description  
username
 

Name of the user you are giving either proxy snapshot administrator or receiver privileges to.  

 
privilege_type
 

Specifies the privilege type you are assigning. Use the following values for to define your privilege_type:

RECEIVER for receiver privileges

PROXY_SNAPADMIN for proxy snapadmin privileges.  

 
list_of_gnames
 

Comma-separated list of object groups you want a user registered for receiver privileges. There must be no whitespace between entries in the list. If you set list_of_gnames to NULL, then the user is registered for all object groups, even object groups that are not yet known when this procedure is called. You must use named notation in order to set list_of_gnames to NULL. An invalid object group in the list causes registration to fail for the entire list.

If you specify a value for list_of_gnames, then do not specify a value for table_of_gnames.  

 
table_of_gnames
 

PL/SQL table of object groups you want a user registered for receiver privileges. The PL/SQL table must be of type DBMS_UTILITY.NAME_ARRAY. This table is 1-based. Use the single value NULL to register the user for all object groups. An invalid object group in the table causes registration to fail for the entire table.

If you specify a value for table_of_gnames, then do not specify a value for list_of_gnames.  

Exceptions

Table 35-7 REGISTER_USER_REPGROUP Procedure Exceptions
Exception  Description  
nonmaster
 

Specified object group does not exist or the invocation database is not a master.  

 
ORA-01917
 

User does not exist.  

 
typefailure
 

Incorrect privilege type was specified.  

REVOKE_ADMIN_ANY_SCHEMA procedure

This procedure revokes the privileges and roles from the replication administrator that would be granted by GRANT_ADMIN_ANY_SCHEMA.

Note:

Identical privileges and roles that were granted independently of GRANT_ADMIN_ANY_SCHEMA are also revoked.  

Syntax

DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_SCHEMA (
   username IN VARCHAR2);

Parameters

Table 35-8 REVOKE_ADMIN_ANY_SCHEMA Procedure Parameters
Parameter  Description  
username
 

Name of the replication administrator whose privileges you want to revoke.  

Exceptions

Table 35-9 REVOKE_ADMIN_ANY_SCHEMA Procedure Exceptions
Exception  Description  
ORA-01917
 

User does not exist.  

REVOKE_ADMIN_SCHEMA procedure

This procedure revokes the privileges and roles from the replication administrator that would be granted by GRANT_ADMIN_SCHEMA.

Note:

Identical privileges and roles that were granted independently of GRANT_ADMIN_SCHEMA are also revoked.  

Syntax

DBMS_REPCAT_ADMIN.REVOKE_ADMIN_SCHEMA (
   username IN VARCHAR2);

Parameters

Table 35-10 REVOKE_ADMIN_SCHEMA Procedure Parameters
Parameter  Description  
username
 

Name of the replication administrator whose privileges you want to revoke.  

Exceptions

Table 35-11 REVOKE_ADMIN_SCHEMA Procedure Exceptions
Exception  Description  
ORA-01917
 

User does not exist.  

UNREGISTER_USER_REPGROUP procedure

This procedure revokes the privileges and roles from the proxy snapshot administrator or receiver that would be granted by the REGISTER_USER_REPGROUP procedure.

Syntax

DBMS_REPCAT_ADMIN.UNREGISTER_USER_REPGROUP (
   username         IN   VARCHAR2,
   privilege_type   IN   VARCHAR2,
   list_of_gnames   IN   VARCHAR2 |
   table_of_gnames  IN   dbms_utility.name_array);

Parameters

Table 35-12 UNREGISTER_USER_REPGROUP Procedure Parameters
Parameter  Description  
username
 

Name of the user you are unregistering.  

 
privilege_type
 

Specifies the privilege type you are revoking. Use the following values for to define your privilege_type:

RECEIVER for receiver privileges

PROXY_SNAPADMIN for proxy snapadmin privileges.  

 
list_of_gnames
 

Comma-separated list of object groups you want a user unregistered for receiver privileges. There must be no whitespace between entries in the list. If you set list_of_gnames to NULL, then the user is unregistered for all object groups registered. You must use named notation in order to set list_of_gnames to NULL. An invalid object group in the list causes unregistration to fail for the entire list.

If you specify a value for list_of_gnames, then do not specify a value for table_of_gnames.  

 
table_of_gnames
 

PL/SQL table of object groups you want a user unregistered for receiver privileges. The PL/SQL table must be of type DBMS_UTILITY.NAME_ARRAY. This table is 1-based. Use the single value NULL to unregister the user for all object groups registered. An invalid object group in the table causes unregistration to fail for the entire table.

If you specify a value for table_of_gnames, then do not specify a value for list_of_gnames.  

Exceptions

Table 35-13 UNREGISTER_USER_REPGROUP Procedure Exceptions
Exception  Description  
nonmaster
 

Specified object group does not exist or the invocation database is not a master.  

 
ORA-01917
 

User does not exist.  

 
typefailure
 

Incorrect privilege type was specified.  


Prev
Next
Oracle
Copyright © 1999 Oracle Corporation.
All Rights Reserved.

Library
Product
Contents
Index