|
Stores the user ID of the database publisher, if any.
-1, NULL, or any user ID
-1
| PUBLIC role | For current user | For other users | |
|---|---|---|---|
| Allowed to set permanently? | Yes, with SET ANY SYSTEM OPTION | No | No |
| Allowed to set temporarily? | No | No | No |
Setting 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.