User's Manual

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