Single-tiered hierarchy

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.

A single-tiered system. The top-tier database, HeadOffice, grants REMOTE privilege to the bottom-tier database. And, the bottom-tier database, RegionalOffice, grants CONSOLIDATE privilege to the top-tier database.

Single-tiered hierarchy

Dbxtract sets privileges automatically

See also