Contents Index Adding Non Data Access Features to UltraLite Applications Enabling user authentication

UltraLite Embedded SQL User's Guide
  Adding Non Data Access Features to UltraLite Applications

Adding user authentication to your application


UltraLite provides an optional built-in user authentication scheme. You can take advantage of this scheme to authenticate users before allowing them to connect to the UltraLite database. By default, UltraLite databases have no user userauthentication mechanism.

The UltraLite user authentication scheme does not provide the permissions features implemented in multi-user database systems and in MobiLink.

For a general description of UltraLite user authentication, see User authentication.

When you create an UltraLite database with user authentication enabled, one authenticated user is created, with user ID DBA and password SQL. 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 case sensitivity of the UltraLite user ID and password is determined by the reference database. If the reference database is case insensitive (the default) then the UltraLite database is also case insensitive, in cluding user authentication.


Enabling user authentication
Managing user IDs and passwords
Sharing MobiLink and UltraLite user IDs

Contents Index Adding Non Data Access Features to UltraLite Applications Enabling user authentication