Sybase DC38133-01-0902-01 manual To create a new user as the publisher Sybase Central, 202

❖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)

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

1.In the Users & Groups folder, right-click the user who has granted PUBLISH permissions and choose Revoke Publisher from the popup menu.

Granting and revoking For Adaptive Server Anywhere, PUBLISH permissions are granted using the

PUBLISH permissions GRANT PUBLISH statement:

[Adaptive Server

GRANT PUBLISH TO userid ;

Anywhere]

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 For Adaptive Server Enterprise, PUBLISH permissions are granted using the

PUBLISH permissions sp_publisher procedure: [Adaptive Server

sp_publisher userid

Enterprise]

202