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

SQL Anywhere 10.0.1 » SQL Remote » SQL Remote Administration » Managing SQL Remote permissions

Managing SQL Remote permissions Next Page

Granting and revoking PUBLISH permissions

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.

Granting and revoking PUBLISH permissions from Sybase Central

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)
  1. In the left pane, select the Users & Groups folder.

  2. From the File menu, choose New > User.

    The Create User wizard appears.

  3. 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.

  4. Click Finish to create the user.

  5. 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)