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]](images/note.png) |
Note: |
|---|---|
|
The DBA account is granted subscription rights by default, which cannot be revoked. |
Example
Example24.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');