Name

REPL_REVOKE — revoke privileges for subscription

Synopsis

REPL_REVOKE ( in publication varchar ,
  in grantee varchar );
 

Description

Revokes Privileges for Subscription. This is called on the publisher to revoke access to the publication from the user account on the publisher. The subscriber will no longer gain access to the publication with this account.

Parameters

publication

The publication name.

grantee

A valid DB account name to be refused subscription rights.

[Note] Note:

The DBA account is granted subscription rights by default, which cannot be revoked.

Example

Example 24.327. Access to 'table_publication' removal for SQL user account 'demo'.

This is to remove permissions to subscribe from SQL user account 'demo' for table_publication publication account.

SQL> DB.DBA.REPL_REVOKE ('table_publication', 'demo');