Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.
Stops a consolidated database from receiving SQL Remote messages from this database.
REVOKE CONSOLIDATE FROM userid
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.
You must have the SYS_REPLICATION_ADMIN_ROLE system role.
Automatic commit. Drops all subscriptions for the user.
Not in the standard.
The following statement revokes consolidated status from the Sam_Singer user ID:
REVOKE CONSOLIDATE FROM Sam_Singer;