Tuto WINDEV 25

358 Part 5: Managing a HFSQL Client/Server database ▶ To grant rights to read the Customer data file: 1.  In the HFSQL Control Center, expand the "WD Full Application" database and double-click the Customer data file (on the left of the screen). 2. On the "Customer" pane, in the "Rights" group, click "Management of 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 the "Defined rights" column and select the green checkmark. 5. Click "Apply" at the bottom of window. The rights become effective. 6. Close the window for managing rights. Similarly, rights can be defined: • on the HFSQL server • on the database • on the database files. In our example, the "Test" user can only browse the records in the Customer data file. If this user tries to perform another action, a message will be displayed: "The Test user has no sufficient rights to XXXX" (where XXXX corresponds to the action performed). Once the account is created, it can be used when the application connects to the server (when HOpenConnection is used). Remark The users and their rights can also be managed by programming with the WLanguage functions. See the online help for more details.