In a multi-tier hierarchy, all remote databases immediately below the current database are granted REMOTE privilege. The database immediately above the current database in the hierarchy is granted CONSOLIDATE privilege.
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 privilege 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 privilege 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 privilege 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 privilege to the RegionalOffice user. This identifies RegionalOffice as the consolidated database for Office; that is RegionalOffice sends messages to Office.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|