Tuto WINDEV 25

354 Part 5: 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 ("Admin" login without password). Using a user account allows you to secure the access to data. Indeed, all application users 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 the application). Do not confuse the management of rights for the Client/Server databases with the user groupware. 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 that was installed in the previous lesson and validate. 4.  The characteristics of HFSQL server are displayed: • the name of HFSQL server as well as the list of databases found on this server are displayed in the left panel. • in the right section of the screen, a new tab allows you to see the characteristics of HFSQL server.