-1, NULL, or any user ID

-1

Can only be set for PUBLIC. You must have the SET ANY SYSTEM OPTION system privilege to set this option. Takes effect immediately.

If the publisher is already set, you must reset this option to -1 or NULL before setting it to another user ID.

Changing the publisher updates the value for the CURRENT PUBLISHER special value.

You can also set and reset the value db_publisher using the GRANT PUBLISH and REVOKE PUBLISH statements, respectively.

• GRANT PUBLISH statement [SQL Remote]
• REVOKE PUBLISH statement [SQL Remote]
• CURRENT PUBLISHER special value
• PUBLISH privilege