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

REVOKE CONSOLIDATE statement

Function 

To stop a consolidated database from receiving SQL Remote messages from this database.

Syntax 

REVOKE CONSOLIDATE FROM userid,...

Permissions 

Must have DBA authority.

Side effects 

Automatic commit. Drops all subscriptions for the user.

See also 

GRANT CONSOLIDATE statement

Description 

CONSOLIDATE permissions must be granted at a remote database for the user ID representing the consolidated database. The REVOKE CONSOLIDATE statement removes the consolidated database user ID from the list of users receiving messages from the current database.

Example 

• The following statement revokes consolidated status from the user ID condb:

  REVOKE CONSOLIDATE FROM condb