User's Manual

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]” [ASA SQL Reference,
page 587]
“GRANT CONSOLIDATE statement” on page 364
“sp_revoke_consolidate procedure” on page 431
370