Changing a password

 Change a password (Sybase Central)

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

  2. Click Users & Groups.

  3. In the Users & Groups list, right-click a user and then click Properties.

  4. Click This User Has A Password.

  5. Complete the Password and Confirm Password fields.

  6. Click Apply.

  7. Click OK.

 Change a password (SQL)

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

  2. Execute an ALTER USER statement.

  • 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
 See also
 Example
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1