Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

REVOKE REMOTE statement [SQL Remote]

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

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.

Must have 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]

• SQL/2003    Vendor extension.

REVOKE REMOTE FROM SamS;