SQL Remote User's Guide
  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

See also 

sp_grant_remote procedure

Description 

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