SQL Remote User's Guide
  Command Reference for Adaptive Server Anywhere

REVOKE CONSOLIDATE statement

Function 

Use this statement 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 

REVOKE CONSOLIDATE statement [SQL Remote]

GRANT CONSOLIDATE statement

sp_revoke_consolidate procedure