UltraLite User's Guide
  Developing 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 ULGrantConnectTo (embedded SQL), ULConnection.GrantConnectTo (C++ API), or JdbcDatabase.grant (Java).

Palm Computing Platform 

Applications on the Palm Computing Platform do not terminate. If you wish to authenticate users whenever they return to an application from some other application, you must include the prompt for user and password information in your PilotMain routine.

Embedded SQL user authentication example
C++ API user authentication example
Java user authentication example