Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT_ADMIN.GRANT_ADMIN_REPGROUP

Purpose

To grant 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. For additional information, refer to

Syntax

The parameter for the GRANT_ADMIN_REPGROUP procedure is described in Table 12 - 177, and the exception is listed in Table 12 - 178. The syntax for this procedure is shown below:

DBMS_REPCAT_ADMIN.GRANT_ADMIN_REPGROUP(userid IN VARCHAR2)

Parameter Description
userid The 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.

Table 12 - 177. Parameter for GRANT_ADMIN_GROUP

Exception Description
ORA-01917 The user does not exist.

Table 12 - 178. Exception for GRANT_ADMIN_GROUP

Parameter	Description
`userid`	The 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.

Exception	Description
ORA-01917	The user does not exist.