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.
The DBA account is granted subscription rights by default, which cannot be revoked.
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');