Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.0 » SQL Remote » SQL Remote Administration » SQL Remote administration » Managing SQL Remote permissions » Granting and revoking REMOTE and CONSOLIDATE permissions


Granting CONSOLIDATE permissions

In the remote database, the publish and subscribe user IDs are inverted compared to the consolidated database. The subscriber (remote user) in the consolidated database becomes the publisher in the remote database. The publisher of the consolidated database becomes a subscriber to publications from the remote database, and is granted CONSOLIDATE permissions.

At each remote database, the consolidated database must be granted CONSOLIDATE permissions. When you produce a remote database by running the Database Extraction utility, the GRANT CONSOLIDATE statement is executed automatically at the remote database.


The following SQL Anywhere statement grants CONSOLIDATE permissions to the hq_user user ID, using the SMTP email system:

ADDRESS 'hq_address';

There is no SEND clause in this statement, so the default is used and messages are sent to the consolidated database every time the Message Agent is run.

In Sybase Central, you can specify the consolidated database for SQL Remote replication.

To set a consolidated database (Sybase Central)

  1. Select the database, and then choose File » Properties.

  2. Click the SQL Remote tab.

  3. Select the This Remote Database Has A Corresponding Consolidated Database option.

  4. Configure the settings.

  5. Click OK to close the Consolidated Database Properties window.