Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

REVOKE CONSOLIDATE statement [SQL Remote]

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

REVOKE CONSOLIDATE FROM userid

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.

Must have DBA authority.

Automatic commit. Drops all subscriptions for the user.

• REVOKE PUBLISH statement [SQL Remote]
• REVOKE REMOTE statement [SQL Remote]
• REVOKE REMOTE DBA statement [SQL Remote]
• GRANT CONSOLIDATE statement [SQL Remote]

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

  REVOKE CONSOLIDATE FROM condb;