Create System Users

System users are established at boot time, and have privileges to join and start SQLFire servers and locators.

  1. Create a system user for SQLFire by specifying user name=password at boot time using the sqlfire.user.UserName system property.

    SQLFire user names are SQL92 identifiers, and are case-sensitive for user authentication. Delimited identifiers are allowed.

    For example, the following property defines a username of "FRed" with the password "java":
  2. Include the property definitions for system users in the file for each SQLFire server and standalone locator.
    For example, this listing shows a file the defines a "locatoradmin" and "serveradmin" system user:
  3. To boot a standalone locator using the above properties file, you would specify a system user with the -user option as in:
    sqlf locator start -user=locatoradmin -password
    Note: Built-in system users are defined when you boot the SQLFire locator. Other SQLFire members that join the system must specify one of the same system users that are defined in the locator. If you need to change the password of a system user, you must stop all members of the distributed system, and then restart them (starting with the locator), specifying the new username definition when you start.

If you leave the -password option empty, SQLFire prompts you for the password.

Note: Keep in mind that sqlfire.user.UserName defines a user credential, and -user specifies an available credential to use for booting the server or locator. Both properties are required. For example, if you specified all properties at the command line rather than in, the command to boot the locator is:
sqlf locator start -auth-provider=BUILTIN 
     -sqlfire.user.locatoradmin=locatorpassword -user=locatoradmin