REVOKE REMOTE FROM userid, ...

REMOTE permissions are 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.

DBA authority

Automatic commit. Drops all subscriptions for the user.

• REVOKE PUBLISH statement [SQL Remote]
• GRANT REMOTE statement [SQL Remote]
• REVOKE REMOTE DBA statement [SQL Remote]
• REVOKE CONSOLIDATE statement [SQL Remote]
• Revoke REMOTE permission