REVOKE CONSOLIDATE statement [SQL Remote]

Stops a consolidated database from receiving SQL Remote messages from this database.

Syntax

REVOKE CONSOLIDATE FROM userid

Remarks

CONSOLIDATE privileges 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.

Privileges

You must have the SYS_REPLICATION_ADMIN_ROLE system role.

Side effects

Automatic commit. Drops all subscriptions for the user.

Standards

ANSI/ISO SQL Standard
Not in the standard.

Example

The following statement revokes consolidated status from the Sam_Singer user ID:
```
REVOKE CONSOLIDATE FROM Sam_Singer;
```