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

SQL Anywhere 11.0.1 (Français) » SQL Remote » SQL Remote Replication Design » SQL Remote replication design and set up » User permissions

 

Multi-tiered hierarchy

In a multi-tier hierarchy, all remote databases immediately below the current database are granted REMOTE permission. The database immediately above the current database in the hierarchy is granted CONSOLIDATE permission.

For example, there is a consolidated database identified by its publisher, HeadOffice, which has a remote database, RegionalOffice. However, the RegionalOffice database also has a remote database: Office.

On the consolidated database, HeadOffice, you:

  • Create a user with the same name as the publisher of the remote database RegionalOffice.

  • Grant REMOTE permission to the user RegionalOffice. This identifies RegionalOffice as a database that receives messages from HeadOffice.

On the RegionalOffice database, you:

  • Create a user with the same name as the publisher of the consolidated database HeadOffice.

  • Grant CONSOLIDATE permission to HeadOffice. This identifies HeadOffice as the consolidated database for RegionalOffice; that is, HeadOffice is the database that sends messages to RegionalOffice.

  • Create a user with the same name as the database immediately below RegionalOffice: Office.

  • Grant REMOTE permission to Office. This identifies Office as a database that receives messages from RegionalOffice.

On the Office database, you:

  • Create a user with the same name as the publisher of the consolidated database: RegionalOffice.

  • Grant Consolidate permission to the RegionalOffice user. This identifies RegionalOffice as the consolidated database for Office; that is RegionalOffice sends messages to Office.

A multi-tier SQL Remote system.