Creating a publisher

Use the following procedures to create users and grant them PUBLISH permission.

Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.
Create a user to serve as the publisher, if one doesn't already exist.
1. In the left pane, click the Users & Groups folder.
2. Click File » New » User.
3. Follow the instructions in the Create User Wizard. Assign the user a password.
In the Users & Groups folder, right-click the user you created, and click Change To Publisher.

Connect to the database as a user with DBA authority.
Execute a CREATE USER statement to create a user to serve as the publisher. Assign the user a password.

For example the following creates a user named cons with the password SQL:
CREATE USER cons IDENTIFIED BY SQL;
Execute a GRANT CONNECT statement to grant CONNECT permission to the user.

For example, the following statement grants CONNECT permission to the user cons:
GRANT CONNECT TO cons IDENTIFIED BY SQL;
Execute a GRANT PUBLISH statement to grant PUBLISH permission to the user.

For example, the following statement grants PUBLISH permission to the user cons:
GRANT PUBLISH TO cons;