Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Remote » Creating SQL Remote systems » User permissions » PUBLISH permission

 

Create a publisher

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

 To a publisher (Sybase Central)
  1. Use the SQL Anywhere 12 plug-in to 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. Choose File » 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)
 See also