❖Tocreate 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.
TheUser Creation wizard appears.
3. Follow the instructions in the wizard. Ensurethat the user has a password
andis granted Remote DBA authority; this enables the user ID to run the
MessageAgent.
4. Click Finish to create the user.
5. In the Users & Groups folder, right-click the user you just created and
chooseChange to Publisher from the popup menu.
❖Tomake an existing user the publisher (Sybase Central)
1. In the Users & Groups folder, right-click a user and choose Change to
Publisherfrom the popup menu.
Youcan also revoke PUBLISH permissions from Sybase Central.
❖Torevoke PUBLISH permissions (Sybase Central)
1. In the Users & Groups folder, right-click the user who has granted
PUBLISHpermissions and choose Revoke Publisher from the popup
menu.
Grantingand revoking
PUBLISHper missions
[AdaptiveSer ver
Anywhere]
ForAdaptive Server Anywhere, PUBLISH permissions are granted using the
GRANTPUBLISH statement:
GRANT PUBLISH TO userid ;
The
userid
isa user with CONNECT permissions on the current database.
Forexample, the following statement grants PUBLISH permissions to user
S_Beaulieu:
GRANT PUBLISH TO S_Beaulieu
TheREVOKE PUBLISH statement revokes the PUBLISH permissions from
thecurrent publisher:
REVOKE PUBLISH FROM userid
Grantingand revoking
PUBLISHper missions
[AdaptiveSer ver
Enterprise]
ForAdaptive Server Enterprise, PUBLISH permissions are granted using the
sp_publisherprocedure:
sp_publisher userid
202