When a database sends a message, a user ID representing that database is included with the message to identify its source to the recipient. This user ID is the publisher user ID of the database. A database can have only one publisher. You can find out who the publisher of a SQL Anywhere database is at any time in Sybase Central by opening the Users & Groups folder.
A publisher is required even for read-only remote databases within a replication system, as even these databases send confirmations to the consolidated database to maintain information about the status of the replication. The GRANT PUBLISH statement for remote SQL Anywhere databases is carried out automatically by the database extraction utility.
You can grant PUBLISH permissions on a SQL Anywhere database from Sybase Central. You must connect to the database as a user with full system or database administrator permissions.
To create a new user as the publisher (Sybase Central)
In the left pane, select the Users & Groups folder.
From the File menu, choose New » User.
The Create User Wizard appears.
Follow the instructions in the wizard. Ensure that the user has a password and is granted Remote DBA authority; this enables the user ID to run the Message Agent.
Click Finish to create the user.
In the Users & Groups folder, right-click the user you just created and choose Change To Publisher from the popup menu.
To make an existing user the publisher (Sybase Central)
In the Users & Groups folder, right-click a user and choose Change To Publisher from the popup menu.
You can also revoke PUBLISH permissions from Sybase Central.
To revoke PUBLISH permissions (Sybase Central)
In the Users & Groups folder, right-click the user who has granted PUBLISH permissions and choose Revoke Publisher from the popup menu.
For SQL Anywhere, PUBLISH permissions are granted using the GRANT PUBLISH statement:
GRANT PUBLISH TO userid;
The userid is a user with CONNECT permissions on the current database. For example, the following statement grants PUBLISH permissions to user S_Beaulieu:
GRANT PUBLISH TO S_Beaulieu;
The REVOKE PUBLISH statement revokes the PUBLISH permissions from the current publisher:
REVOKE PUBLISH FROM userid;
SELECT CURRENT PUBLISHER;
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|