Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

db_publisher option

Stores the user ID of the database publisher, if any.

Allowed values

-1, NULL, or any user ID

Default

-1

Scope
  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
Remarks

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.