Replication Management API Reference, 117 of 179

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. 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 8-212 REGISTER_USER_REPGROUP Procedure Parameters

Parameter	Description
username	Name of the user to whom you are giving either proxy snapshot 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 snapshot administration 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.
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 (the positions start at 1 and increment by 1). 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.

Exceptions

Table 8-213 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.