REVOKE REMOTE statement [SQL Remote]

Stops a user from being able to receive SQL Remote messages from this database.

Syntax

REVOKE REMOTE FROM userid, ...

Remarks

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.

Privileges

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit. Drops all subscriptions for the user.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

REVOKE REMOTE FROM Sam_Singer;