UltraLite Static Java User's Guide
  Adding Non Data Access Features to UltraLite Applications
    Adding user authentication to your application

Managing user IDs and passwords

There is a common sequence of events to managing user IDs and passwords.

1. New users have to be added from an existing connection. As all UltraLite databases are created with a default user ID and password of DBA and SQL, respectively, you must first attempt to connect as this initial user and implement user management only upon successful connection.

2. You cannot change a user ID: you add a user and delete an existing user. A maximum of four user IDs are permitted for each UltraLite database.

3. To change the password for an existing user ID, call the same function as adding a user ID. This function is JdbcDatabase.grant.

User authentication example