REVOKE REMOTE statement [SQL Remote]

Use this statement to stop a user from being able to receive SQL Remote messages from this database.

Syntax
REVOKE REMOTE FROM userid, ...
Remarks

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.

Permissions

Must have DBA authority.

Side effects

Automatic commit. Drops all subscriptions for the user.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

Example
REVOKE REMOTE FROM SamS;