Configuring User Authentication

When you enable user authentication, a valid username and password are required in order to start up a new SQLFire member in the distributed system; join an existing distributed system; and connect to a running SQLFire distributed system. SQLFire verifies the name and password against a repository of users that is defined for the system. Authentication is not enabled by default.

SQLFire authenticates users credentials against a repository of users that you specify. SQLFire provides a built-in repository, or you can configure SQLFire to use an LDAP directory service or a custom authentication service that you create.

Note: The SQLFire built-in authentication mechanism is suitable only for development and testing purposes. Production systems should use an LDAP repository or custom directory service, and should secure network connections using SSL/TLS.

After SQLFire authenticates a user, it grants the user access to the SQLFire distributed system, either by starting up the SQLFire member in a new distributed system, joining the member to an existing distributed system, or simply connecting to a distributed system as a client. Authenticated users may also access to database objects according to the SQL authorization configuration. (SQL authorization is not enabled by default).

Note: Because SQLFire can be embedded within a Java application, it is also possible to deploy a system in which the Java application, rather than the embedded SQLFire process, handles user authentication.