REVOKE CONSOLIDATE statement [SQL Remote]

Use this statement to stop a consolidated database from receiving SQL Remote messages from this database.

Syntax
REVOKE CONSOLIDATE FROM userid
Remarks

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.

Permissions

Must have DBA authority.

Side effects

Automatic commit. Drops all subscriptions for the user.

See also
Standards and compatibility
  • SQL/2003   Vendor extension.

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

    REVOKE CONSOLIDATE FROM condb;