In a single-tiered hierarchy, there is one consolidated database with one or more remote databases underneath. In such a hierarchy, the consolidated database grants REMOTE permission to the publishers of the remote databases. Each remote database grants CONSOLIDATE permission to the consolidated database.
For example, there is a consolidated database identified by its publisher, HeadOffice, and a remote database identified by its publisher, RegionalOffice.
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 RegionalOffice. This identifies RegionalOffice as a remote database of the HeadOffice.
On the remote database, RegionalOffice, you:
Create a user with the same name as the publisher of the consolidated database: HeadOffice.
Grant CONSOLIDATE permission to RegionalOffice. This identifies RegionalOffice as a remote database of the HeadOffice.
By default, the Extraction utility (dbxtract) and the Extract Database Wizard grant the appropriate PUBLISH and CONSOLIDATE permissions to users in the remote databases.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |