Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • Rights required to add a user
  • Rights management
  • "SuperUser" user
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WindowsLinuxPHPWEBDEV - Browser code
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Stored procedures
<Connection variable>.AddUser (Function)
In french: <Variable Connexion>.AjouteUtilisateur
HFSQL Client/ServerAvailable only with this kind of connection
Adds a user to a database. All the characteristics of the user must be entered in the variables for user management.
// Describe the connection
MyConnection is Connection
// Open the connection
// Associate the data file with the connection
// Characteristics of the new user
HUser.Login = "FLO"
HUser.Password = "FLOP"
HUser.FullName = "Flora"
HUser.Email = ""
HUser.Phone = ""
HUser.Groups = "ADMIN" + CR + "TEST"
// Add the user
IF MyConnection.AddUser() = True THEN
Info("User added")
<Result> = <Connection>.AddUser()
<Result>: Boolean
  • True if the user was added,
  • False if an error occurred. HError is used to identify the error.
<Connection>: Connection variable
Name of the Connection variable that describes the connection to which a user must be added.

Rights required to add a user

To add a user, you must have the following rights:
  • Rights to manage the users (hRightsManageUser constant).
  • Rights to see the users (hRightsSeeUser constant).
These constants are used in <Connection variable>.InfoServerRights and <Connection variable>.ModifyServerRights.

Rights management

No rights are granted by default to a new user (if this user is associated with no group).
If this user is associated with one or more groups, the rights associated with this group are granted to the user (the user "inherits" the rights associated with the group).
The following functions are used to grant rights to a user:
For more details, see Managing the rights in HFSQL Client/Server.

"SuperUser" user

If HUser.SuperUser = True, the user rights are not checked during an action. Therefore, all the actions can be performed by this user.
Component: wd290hf.dll
Minimum version required
  • Version 25
This page is also available for…
Click [Add] to post a comment

Last update: 09/07/2023

Send a report | Local help