ASA SQL Reference
  SQL Statements

REVOKE REMOTE statement [SQL Remote]

Description 

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

Syntax 

REVOKE REMOTE FROM userid, ...

Usage 

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]

sp_revoke_remote procedure

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

Example 

REVOKE REMOTE FROM SamS