Contents Index Managing SQL Remote permissions Granting and revoking REMOTE and CONSOLIDATE permissions

SQL Remote User's Guide
  SQL Remote Administration
    Managing SQL Remote permissions

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 an Adaptive Server 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 Adaptive Server 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 an Adaptive Server 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 User Creation 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)

You can also revoke PUBLISH permissions from Sybase Central.

To revoke PUBLISH permissions (Sybase Central)

Granting and revoking PUBLISH permissions [Adaptive Server Anywhere] 

For Adaptive Server 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
Granting and revoking PUBLISH permissions [Adaptive Server Enterprise] 

For Adaptive Server Enterprise, PUBLISH permissions are granted using the sp_publisher procedure:

sp_publisher 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:

exec sp_publisher 'S_Beaulieu'
go

The database is set to have no publisher by executing the sp_publisher procedure with no argument:

exec sp_publisher
go
Notes on PUBLISH permissions 

Contents Index Managing SQL Remote permissions Granting and revoking REMOTE and CONSOLIDATE permissions