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 publisher.
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 database that receives messages from 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 HeadOffice. This identifies HeadOffice as the consolidated database for RegionalOffice; that is, HeadOffice is the database that sends messages to RegionalOffice.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|