User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

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

Syntax

     REVOKE CONSOLIDATE FROM userid,...

Usage

Anywhere. This statement is applicable only to SQL Remote.

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

     REVOKE CONSOLIDATE FROM condb