Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_REPGROUP

Purpose

To revoke the privileges and roles from the replication administrator that would be granted by GRANT_ADMIN_ANY_REPGROUP. For additional information, refer to

Attention: Identical privileges and roles that were granted independently of GRANT_ADMIN_ANY_REPGROUP are also revoked.

Syntax

The parameter for the REVOKE_ADMIN_ANY_REPGROUP procedure is described in Table 12 - 179, and the exception is listed in Table 12 - 180. The syntax for this procedure is shown below:

DBMS_REPCAT_ADMIN.REVOKE_ADMIN_ANY_REPGROUP(
						userid IN VARCHAR2)

Parameter Description
userid The name of the replication administrator whose privileges you want to revoke.

Table 12 - 179. Parameter for REVOKE_ADMIN_ANY_REPGROUP

Exception Description
ORA-01917 The user does not exist.

Table 12 - 180. Exception for REVOKE_ADMIN_ANY_REPGROUP

Parameter	Description
`userid`	The name of the replication administrator whose privileges you want to revoke.

Exception	Description
ORA-01917	The user does not exist.