Oracle9i Replication Management API Reference
Release 1 (9.0.1)

Part Number A87502-01
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback

Go to previous page Go to beginning of chapter Go to next page

DBMS_REPCAT_ADMIN, 4 of 7


REGISTER_USER_REPGROUP Procedure

This procedure assigns proxy materialized view administrator or receiver privileges at the master site or master materialized view site for use with remote sites. This procedure grants only the necessary privileges to the proxy materialized view administrator or receiver. It does not grant the powerful privileges granted by the GRANT_ADMIN_SCHEMA or GRANT_ADMIN_ANY_SCHEMA procedures.

See Also:

Appendix A, "Security Options" for more information about 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)};


Note:

This procedure is overloaded. The list_of_gnames and table_of_gnames parameters are mutually exclusive. 



Parameters

Table 21-6 REGISTER_USER_REPGROUP Procedure Parameters
Parameter  Description 
username
 

Name of the user to whom you are giving either proxy materialized view administrator or receiver privileges. 

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 materialized view administration privileges

 
list_of_gnames
 

Comma-separated list of replication groups you want a user registered for receiver privileges. There must be no spaces between entries in the list. If you set list_of_gnames to NULL, then the user is registered for all replication groups, even replication 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 replication group in the list causes registration to fail for the entire list.  

table_of_gnames
 

PL/SQL index-by table of replication groups you want a user registered for receiver privileges. The PL/SQL index-by table must be of type DBMS_UTILITY.NAME_ARRAY. This table is 1-based (the positions start at 1 and increment by 1). Use the single value NULL to register the user for all replication groups. An invalid replication group in the table causes registration to fail for the entire table. 

Exceptions

Table 21-7 REGISTER_USER_REPGROUP Procedure Exceptions
Exception  Description 
nonmaster
 

Specified replication group does not exist or the invocation database is not a master site or master materialized view site. 

ORA-01917
 

User does not exist. 

typefailure
 

Incorrect privilege type was specified. 


Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2001, Oracle Corporation.

All Rights Reserved.
Go To Documentation Library
Home
Go To Product List
Book List
Go To Table Of Contents
Contents
Go To Index
Index

Master Index

Feedback