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

To a publisher (Sybase Central)

1. Connect to the database as a user with DBA authority.

2. Create a user to serve as the publisher, if one doesn't already exist.

   1. In the left pane, select the Users & Groups folder.

   2. From the File menu, choose New » User.

   3. Follow the instructions in the Create User Wizard. Assign the user a password.

3. In the Users & Groups folder, right-click the user you created, and choose Change To Publisher.

To create a publisher (SQL)

1. Connect to the database as a user with DBA authority.

2. 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;

3. Execute a GRANT CONNECT statement to grant CONNECT permission to the user. See GRANT statement.

   For example, the following statement grants CONNECT permission to the user cons:

   GRANT CONNECT TO cons IDENTIFIED BY SQL;

4. Execute a GRANT PUBLISH statement to grant PUBLISH permission to the user. See GRANT PUBLISH statement [SQL Remote].

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

   GRANT PUBLISH TO cons;

Extraction utility (dbxtract)

When a remote database is extracted by the Extraction utility (dbxtract) or the Extract Database Wizard, the remote user becomes the publisher of the remote database, and is granted PUBLISH permission.

See also

• Revoke PUBLISH permission
• View the publisher