Oracle7 Server Distributed Systems Volume II: Replicated Data

DBMS_REPCAT_AUTH.REVOKE_SURROGATE_REPCAT

Purpose

To revoke the privileges granted to the surrogate repcat user. For additional information, refer to

Syntax

The parameters for the REVOKE_SURROGATE_REPCAT procedure are described in Table 12 - 185, and the exceptions are listed in Table 12 - 186. The syntax for this procedure is shown below:

DBMS_REPCAT_AUTH.REVOKE_SURROGATE_REPCAT(userid IN VARCHAR2)

Parameter Description
userid The name of the user from whom you wish to revoke the necessary privileges.

Table 12 - 185. Parameters for REVOKE_SURROGATE_REPCAT

Exception Description
ORA-01917 The user does not exist

Table 12 - 186. Exception for REVOKE_SURROGATE_REPCAT

Parameter	Description
`userid`	The name of the user from whom you wish to revoke the necessary privileges.

Exception	Description
ORA-01917	The user does not exist