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.
Dbxtract sets permissions automatically |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |