Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 17. Command Reference for Adaptive Server Anywhere       

REVOKE REMOTE statement

Function 

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

Syntax 

REVOKE REMOTE FROM userid,...

Permissions 

Must have DBA authority.

Side effects 

Automatic commit. Drops all subscriptions for the user.

Description 

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.

Example 

REVOKE REMOTE FROM SamS