REVOKE REMOTE FROM userid, ...

REMOTE privilege is required for a user ID to receive messages in a SQL Remote replication installation. The REVOKE REMOTE statement removes a user ID from the list of users receiving messages from the current database.

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Automatic commit. Drops all subscriptions for the user.

• REVOKE PUBLISH statement [SQL Remote]
• GRANT REMOTE statement [SQL Remote]
• REVOKE ROLE SYS_REPLICATION_ADMIN_ROLE statement [MobiLink] [SQL Remote]
• REVOKE CONSOLIDATE statement [SQL Remote]
• Revoking REMOTE privilege