Replication Management API Reference, 120 of 179

UNREGISTER_USER_REPGROUP procedure

This procedure revokes the privileges and roles from the proxy snapshot administrator or receiver that were 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)};

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

Parameters

Table 8-218 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 snapshot administration 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.
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 (the positions start at 1 and increment by 1). 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.

Exceptions

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