Now that we know how to create and/or adapt a site for HFSQL Client/Server, we will see how to manage its database.

• a specific configuration on the computers (install an HFSQL server, etc.).
• management via the HFSQL Control Center.

To use an HFSQL Client/Server database, an HFSQL server must be installed on the server. Several HFSQL servers that use different ports can be installed on the same computer.

The HFSQL Control Center is used to fully manage HFSQL Client/Server databases and servers.

• To open HFSQL Control Center from WEBDEV and access the data:
  1. In the WEBDEV menu, on the "Tools" tab, in the "Database" group, click "HFSQL". The HFSQL Control Center is displayed.
  2. The HFSQL Control Center home window appears. The analysis of the current project is automatically selected.
     
  3. Validate the screen. The HFSQL Control Center is displayed. This start mode allows you to see the different data files linked to the analysis of the current project.
  4. Click the vertical tab named "HFSQL C/S" if necessary. The list of HFSQL Client/Server data files appears.
     
     The Control Center lists the Client/Server data files found in the analysis linked to the current project. No connection is established: the names of the data files are grayed out.
  5. To view the records in the data files, double-click one of the data files in the list on the left (for example, "Order"). If the HFSQL Control Center does not recognize all the connection parameters, a window will allow you to establish the connection with the HFSQL Client/Server server used. If this window is displayed, specify the password and validate.
  6. The information of the selected data file that uses this connection is displayed in a new "Order" tab. This information is available in several vertical tabs:
     
  • The "Description" tab shows information about the data files (data file items, etc.).
  • The "Content" tab shows the records in the data files.

A single user account is created when installing an HFSQL server and creating a database: the administrator account. By default, the administrator can use "Admin" as username and leave the password empty. Reminder: the password can be set when installing the HFSQL server.

	Caution!	The user rights specified in the HFSQL Control Center are granted for the database and not for accessing the site. The permissions granted for the Client/Server databases should not be confused with the User Groupware, which we saw in a previous lesson.

Some users may not have rights to write to some data files, for example. To do a simple test, we will create a user and allow the user to see the records in the Customer data file.

• To directly connect to the database on the server:
  1. Expand the menu at the top left of the HFSQL Control Center and select "Connect to an HFSQL server".
  2. The HFSQL Control Center home window appears.
     
  3. The option "Connect to an HFSQL server" is selected by default. Specify the characteristics of the server installed in the previous lesson.
  4. The characteristics of the HFSQL server are displayed in different panels:
     • the name of the HFSQL server and the list of databases are displayed in the left panel.
     • in the right section of the screen, a new tab appears and shows the characteristics of the HFSQL server.
       
  5. On the right section of the screen, select the "Users" tab. This tab is used to manage the server users.
  6. Only the "Admin" user exists at this point.
     
  7. To create a new user, in the ribbon, in the "Users" group, click "New". The user properties window opens.
  8. Enter the following information:
     
     (use "Test" as password for example).
     

     	Note	Several characteristics can be observed: Superuser: Users defined as "Superusers" are allowed to perform all actions on the server, databases and data files. Account enabled: If this option is not checked, the user is created but is not enabled (users on leave, for example). Password expiration: You can specify a password valid only for a given number of days (configurable).
  9. Validate the user creation. By default, no rights are granted to this user.

• To grant rights to connect to the database:
  1. In the HFSQL Control Center, double-click the "Full_WEBDEV_Site" database. A new tab appears.
  2. On the "Full_WEBDEV_Site" tab, in the "Rights" group, click "Manage rights".
  3. Select the "Test" user in the list of users.
  4. In the list of rights, for the action named "Rights to connect to the server (encrypted and unencrypted connection)", click in the "Defined rights" column and select the green checkmark.
     
  5. Click "Apply" at the bottom of the window. The rights become effective.
  6. Close the rights management window.

• To grant rights to read the Customer data file:
  1. In the HFSQL Control Center, expand the "Full_WEBDEV_Site" database, and then double-click the Customer data file (on the left of the screen).
  2. On the "Customer" tab, in the "Rights" group, click "Manage rights".
  3. Select the "Test" user in the list of users.
     
  4. In the list of rights, for the action named "Rights to read the records of a file", click in the "Defined rights" column and select the green checkmark.
  5. Click "Apply" at the bottom of the window. The rights become effective.
  6. Close the rights management window.

• on the HFSQL server,
• on the database,
• on the database files.

	Note	The users and their rights can also be managed through programming with the WLanguage functions. For more details, see HFSQL Client/Server management functions.