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

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

Standards and compatibility

Example

REVOKE REMOTE FROM SamS;