Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 18. Command Reference for Adaptive Server Enterprise       

sp_revoke_remote procedure

Purpose 

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

Syntax 

sp_revoke_remote user_name

Argument	Description
user_name	The user ID who will no longer be able to receive SQL Remote messages.

See also 

sp_grant_remote procedure

Description 

REMOTE permissions are required for a user ID to receive messages in a SQL Remote replication installation. The sp_revoke_remote procedure removes a user ID from the list of users receiving messages from the current database.

Example 

• The following statement revokes remote permissions from user Field User:

  sp_revoke_remote 'Field user'
  go