User's Manual

Chapter 18. Command Reference for Adaptive Server Enterprise
sp_publisher procedure
Purpose To set the publisher of the current database, or to remove the publisher.
Syntax sp_publisher [ user_name ]
Argument Description
user_name The user ID to be identifies as the publisher for the
database.
See also “Managing SQL Remote permissions” on page 201.
“GRANT PUBLISH statement” on page 365
Description Each database in a SQL Remote installation is identified in outgoing
messages by a user ID, called the publisher. The sp_publisher procedure
sets the publisher user ID associated with these outgoing messages.
Each database can have at most one publisher; if a publisher already exists,
sp_publisher changes the name of the publisher.
If no user_name argument is provided, the current publisher is removed, so
that the database has no publisher. Only the permission to be the publisher is
removed; the user ID is not removed from the database.
Examples
♦ The following statement identifies the user ID joe as the publisher of the
current database:
sp_publisher joe
go
♦ The following statement sets the current database to have no publisher:
sp_publisher
go
409