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 connect as this initial user.

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.

For more information about granting or revoking connection authority, see grantConnectTo method and revokeConnectFrom method.

♦  To add a user or change the password for an existing user

1. Connect to the database as an existing user.

2. Grant the user connection authority with the desired password.

   conn.grantConnectTo("Robert", "newPassword");

♦  To delete an existing user

1. Connect to the database as an existing user.

2. Revoke the user's connection authority as follows.

   conn.revokeConnectFrom("Robert");