PUBLISH   Every database in a SQL Remote system publishes information. Therefore, every database must have a publisher. To create a publisher, grant one user PUBLISH privilege. The publisher user must be unique throughout the SQL Remote system. When sending data, the publisher represents the database. For example, when a database sends a message, its publisher user name is included with the message. When a database receives a message, it can identify the database that sent the message by the publisher name in the message.

REMOTE   A database, such as a consolidated database, that sends messages to other databases must specify which remote databases it sends messages to. To specify these remote databases on the consolidated database, grant REMOTE privilege to the publishers of the remote databases. REMOTE privilege identifies databases that receive messages from the current database.

CONSOLIDATE   Each remote database must specify the consolidated database that it receives messages from. To specify a consolidated database on the remote database, grant CONSOLIDATE privilege to the publisher of the consolidated database. A remote database can only receive messages from one consolidated database. CONSOLIDATE privilege identifies the database that sends messages to this remote database.