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.
SQL/2003 Vendor extension.
REVOKE CONSOLIDATE FROM condb;
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|