Each database in a SQL Remote installation is identified in outgoing messages by a user ID, called the publisher. The GRANT
PUBLISH statement identifies the publisher user ID associated with these outgoing messages.
Only one user ID can have PUBLISH authority. The user ID with PUBLISH authority is identified by the special value CURRENT
PUBLISHER. The following query identifies the current publisher:
SELECT CURRENT PUBLISHER;
If there is no publisher, the special constant is NULL.
The CURRENT PUBLISHER special value can be used as a default setting for columns. It is often useful to have a CURRENT PUBLISHER
column as part of the primary key for replicating tables, as this helps prevent primary key conflicts due to updates at more
than one site.
To change the publisher, you must first drop the current publisher using the REVOKE PUBLISH statement, and then create a new
publisher using the GRANT PUBLISH statement.