Product Documentation

FairCom DB Standalone SQL Service

Previous Topic

Next Topic

Adding and Maintaining Users

ODBC and other SQL users will need to authenticate to the FairCom DB Standalone SQL Service. The FairCom DB Standalone SQL Service includes extensive SQL access controls which can be unique to each user including SELECT INSERT, UPDATE, and DELETE access at the column level. FairCom DB Standalone SQL Service for standalone provides an assortment of utilities to manage SQL user accounts. This information is maintained in the FAIRCOM.FCS file under the service process working area and should be regularly backed up and protected from external access.

Covered in this section:

  • FairCom DB utilities: ISQL, ctadmn, ctpass, etc.
  • Default ADMIN "super user" account
  • Adding users
  • Username/Password limits and restrictions
  • The User's password

FairCom DB Utilities

The following utilities are useful for administration as well as maintaining users and passwords:

isql.exe - The FairCom DB SQL Interactive SQL utility (ISQL) provides an industry-standard "command processing" interface to the FairCom DB SQL Database Engine. (Installed by the FairCom DB Standalone SQL Service installation program).

ctadmn - Administrator Utility. (Installed by the FairCom DB Standalone SQL Service installation program)

ctpass - Utility to allow users to change their password.

ctcpvf - Master password verification file utility. (Installed by the FairCom DB Standalone SQL Service installation program)

ctencrypt - Utility to change the master password. (Installed by the FairCom DB Standalone SQL Service installation program)

sa_admin - Scriptable command-line utility for performing security administration.

c-treeSecurityAdmin - GUI tool for performing security administration.

For more information on these utilities, see the Command-Line Tools book.

Default ADMIN Account

When it is initially installed, FairCom DB recognizes only one user: The Administrator. This "super user" has the unchangeable User ID name of ADMIN and the initial password of ADMIN. Administrator functions can be run by anyone with knowledge of the Administrator User ID and password.

The first thing to do is to change the initial password and keep the new password secure.

Adding Users

The Administrator, or "super user", is the only user with a preset, and unchangeable, User ID (ADMIN). The Administrator uses the ADMIN User ID and their private password to obtain exclusive access to the Administrator utilities needed to carry out the responsibilities discussed in this section.

The Administrator can create new User IDs (and passwords) for other users, who then logon with these names. This includes new members to the ADMIN group with limited Administrator capabilities.

Username/Password Limits and Restrictions

User IDs can be up to 31 characters long. Characters can be letters, numbers, or punctuation marks. User IDs are not case sensitive (i.e., upper and lower case characters are treated as the same).

User passwords can be up to 63 characters. Characters can be letters, numbers, or punctuation marks. Passwords are case sensitive (i.e., upper case and lower case characters are treated as different).

Note: Users, including ADMIN, can use the ctpass utility to change their own password. Members of the ADMIN group can use the FairCom DB Server Administrator Utility to change the password for a User ID that is not a member of the ADMIN group; only the super ADMIN account (named ADMIN) can change a password for an account that is a member of the ADMIN group.

The User's Password

The following steps are required for a user to change the password associated with their own User ID:

  1. Run the utility program ctpass as any other program in the environment.
  2. Enter your current User ID.
  3. Enter the current password for your User ID, if you have one. (Maximum 63 characters. Maximum nine characters for V9 and prior).
  4. Continue by entering the current name of the FairCom Server (i.e., the default name or another name, supplied in the FairCom Server configuration file).
  5. Now change your password by entering the new password.
  6. To be sure to enter the new password, you may be asked to enter it twice before it will be accepted. If the same name is not entered both times, try again.

Note: Whenever input is requested, the user may enter a question mark (?) to receive HELP.

After the new password is entered and confirmed, a message saying your User ID password has been successfully updated will be displayed. After being updated successfully, the new password must be used with the User ID to log on to the FairCom Server.

Note: All users can change their own passwords. In addition, users who are members of the ADMIN group can change the password of all accounts that are not members of the ADMIN group. Only the super ADMIN account (named ADMIN) can change a password for an account that is a member of the ADMIN group.

TOCIndex