UltraLite Database User's Guide
  UltraLite Databases

User authentication

UltraLite provides optional database user IDs and passwords for user authentication. Unlike Adaptive Server Anywhere and other multi-user database systems, UltraLite user IDs are used for authentication only, not for permission checking or object ownership within a database. By default, UltraLite databases have no user authentication.

UltraLite provides a built-in scheme to authenticate users before allowing them to connect to the UltraLite database.

When an UltraLite database is created, it has an initial user ID of DBA, with a password of SQL. These are also default values on connection parameters. You can avoid user authentication by not supplying uid or pwd connection parameters when connecting.

UltraLite permits up to four different users to be defined at a time, with both user ID and password being less than 16 characters long.

Each user has full access to the database once successfully authenticated. The user authentication scheme does not provide the permissions features implemented in multi-user database systems and in MobiLink synchronization.

If the database is case insensitive (the default) then the user ID and password are case insensitive. If the database is case sensitive, then the password is case sensitive.

UltraLite user IDs are separate from MobiLink user names and from user IDs in any reference database or consolidated databases you use during development and after deployment. In many cases you may wish to provide code so that the values used for each are the same, but they do remain distinct concepts. For example, in the CustDB sample application, you are prompted for an employee number when starting the application. This employee number identifies the database for the purposes of MobiLink synchronization, and is not an UltraLite user ID for connection or data access purposes.

To add user authentication to your application

1. Connect to the database using the default uid and pwd parameters.

   New users have to be added from an existing connection.

2. Prompt for a user ID and password.

3. Grant access to this user.

   Use the ULConnection.GrantConnectTo method to enable user authentication and provide access to a specific user ID and password combination.

4. Optionally, revoke access from the original user ID.

For more information 

• UltraLite for MobileVB    See User authentication.

• UltraLite ActiveX    See User authentication.

• Native UltraLite for Java    See User authentication.

• UltraLite.NET    See User authentication.

• UltraLite for C++    See User authentication.

• UltraLite for embedded SQL    See Adding user authentication to your application.

• UltraLite static C++    See Adding user authentication to your application.

• UltraLite static Java    See Adding user authentication to your application.