Creating a user

  • User IDs cannot:

    • begin with white space, single quotes, or double quotes
    • end with white space
    • contain semicolons
  • Passwords are case-sensitive and they cannot:

    • begin with white space, single quotes, or double quotes
    • end with white space
    • contain semicolons
    • be longer than 255 bytes in length
 Create a new user or group (Sybase Central)

You must have DBA authority to create new users.

  1. Use the SQL Anywhere 12 plug-in to connect to the database as a user with DBA authority.

  2. To create a new user, right-click Users & Groups and then click New » User.

  3. Follow the instructions in the Create User Wizard.

 Create a new user (SQL)

You must have DBA authority to create new users.

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

  2. Execute a CREATE USER statement with IDENTIFIED BY.

 See also
 Example