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

SQL Anywhere 17 » UltraLite - Database Management and Developer Guide » UltraLite database reference » UltraLite options

UltraLite PWD creation option

Specify the password for the default user.


If you do not set both the user ID and password, UltraLite opens connections with UID=DBA and PWD=sql.


For Android devices, you can use Configuration.setPassword as an alternative to setting this creation option.

Every user of a database has a password. UltraLite supports up to four user ID/password combinations.

You can set passwords to NULL or an empty string.

A random 4-byte salt value is generated when a new user is created or an existing user changes their password. The salt value is appended to the user's password when calculating the password hash and is stored in the database along with the hash. Salting significantly decreases vulnerability to dictionary attacks and also ensures that users with the same password will have different password hashes.

This creation option is not encrypted. However, UltraLite hashes the password before saving it, so you can only modify a password using SQL Central.