Use the following procedures to grant CONSOLIDATE permission to a user.
It is recommended that you grant CONSOLIDATE permission to the publisher of the consolidated database.
Connect as a user with DBA authority.
In the left pane, click the database, and then choose File » Properties.
Click the SQL Remote tab.
Select This Remote Database Has A Corresponding Consolidated Database.
Configure the Message Type, Address, and Send Frequency settings.
Click OK to close the Consolidated Database Properties window.
Execute a GRANT CONNECT statement to grant CONNECT permission to the publisher of the consolidated database. See GRANT statement.
GRANT CONNECT TO cons;
Execute a GRANT CONSOLDIATE statement to grant CONSOLIDATE permission to the consolidated user. See GRANT CONSOLIDATE statement [SQL Remote].
For example, the following statement grants CONSOLIDATE permission to the hq_user user and specifies that the consolidated database uses the SMTP email system:
GRANT CONSOLIDATE TO hq_user TYPE SMTP ADDRESS 'hq_address';
There is no SEND clause in this GRANT CONSOLIDATE statement, so SQL Remote sends messages to the consolidated database and then stops.
For example, the following statement grants CONSOLIDATE permission to the cons user and specifies that the consolidated database uses the FILE system:
GRANT CONNECT TO "cons" IDENTIFIED BY SQL; GRANT CONSOLIDATE TO "cons" TYPE "FILE" ADDRESS 'cons'; GRANT CONNECT TO "rem1" IDENTIFIED BY SQL; GRANT PUBLISH TO "rem1"; CREATE REMOTE MESSAGE TYPE FILE ADDRESS 'rem1';
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|