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.
In the left pane, select the Users & Groups folder.
Choose File » New » User.
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 choose 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. See GRANT statement.
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. See GRANT PUBLISH statement [SQL Remote].
For example, the following statement grants PUBLISH permission to the user cons:
GRANT PUBLISH TO cons; |
Discuss this page in DocCommentXchange.
|
Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0 |