UltraLite ActiveX User's Guide
  Understanding UltraLite ActiveX Development

User authentication

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 a user with DBA authority.

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

   'eMbedded Visual Basic
   conn.GrantConnectTo("Robert", "newPassword")

   // JScript
   conn.GrantConnectTo("Robert", "newPassword");

To delet an existing user

1. Connect to the database as a user with DBA authority.

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

   'eMbedded Visual Basic
   conn.RevokeConnectFrom("Robert")

   // JScript
   conn.RevokeConnectFrom("Robert");