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

sp_revoke_consolidate procedure

Purpose 

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

Syntax 

sp_revoke_consolidate user_name

Argument	Description
user_name	The user ID who will no longer be able to act as a consolidated database.

See also 

sp_grant_consolidate procedure

Description 

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

Example 

• The following statement revokes consolidated permissions from user hq_user:

  sp_revoke_consolidate hq_user
  go