UltraLite Embedded SQL 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 ULGrantConnectTo.

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.

User authentication example