Oracle7 Server Distributed Systems Volume II: Replicated Data

Contents Index Home Previous Next

DBMS_REPCAT_ADMIN.REVOKE_ADMIN_REPGROUP

Purpose

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

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

Syntax

The parameter for the REVOKE_ADMIN_REPGROUP procedure is described in Table 12 - 181, and the exception is listed in Table 12 - 182. The syntax for this procedure is shown below:

DBMS_REPCAT_ADMIN.REVOKE_ADMIN_REPGROUP(userid IN VARCHAR2)

Parameter Description
userid The name of the replication administrator whose privileges you want to revoke.
Table 12 - 181. Parameter for REVOKE_ADMIN_REPGROUP

Exception Description
ORA-01917 The user does not exist.
Table 12 - 182. Exception for REVOKE_ADMIN_ANY_REPGROUP


Contents Index Home Previous Next