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 privilege to the publishers of the remote databases. Each remote database grants CONSOLIDATE privilege 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 privilege 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 privilege 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 © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|