Tuto WEBDEV 25

390 Part 11: Managing a HFSQL Client/Server database Creating a user account in the HFSQL Control Center A single user account is created when installing a HFSQL server and when creating a database: the administrator account. By default, the administrator has the login "Admin" and no password. Reminder: it is possible to customize the password when installing the HFSQL server. Using a user account allows you to secure the access to data. Indeed, all the users of the site are not administrators. Specific rights can be granted to each user (or group of users). Caution! The user rights specified in the HFSQL Control Center are granted for the database and not for accessing the site. Do not confuse right management for the Client/Server databases with the user groupware, which we’ve seen in a previous lesson. Some users may not have the rights to write into some data files for example. To run a simple test, we are going to create a user and allow this user to see the records in the Customer data file. ▶ To directly connect to the database found on the server: 1. Expand the menu found at the top left of HFSQL Control Center and select "Connect to a HFSQL server". 2.  The home window of HFSQL Control Center is displayed. 3.  The option "Connect to a HFSQL server" is selected by default. Specify the characteristics of the server installed in the previous lesson.