ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Help / WLanguage / Managing databases / HFSQL / HFSQL Client/Server functions
  • Rights required to add a user
  • Rights management
  • "SuperUser" user
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac CatalystUniversal Windows 10 App
Others
Stored procedures
Adds a user to a database. All the characteristics of the user must be entered in the variables for user management.
Example
// Describe the connection
HDescribeConnection("MyConnection", "Julia", "Password", "MyHFServer", ...
"MyDatabase", hAccessHFClientServer, hORead)
// Open the connection
HOpenConnection("MyConnection")
// Associate the data file with the connection
HChangeConnection(Customer, "MyConnection")
// Characteristics of the new user
HUser.Login = "FLO"
HUser.Password = "FLOP"
HUser.FullName = "Flora"
HUser.Email = "Flo@myaddress.eu"
HUser.Phone = "01.67.40.47.58"
HUser.Groups = "ADMIN" + CR + "TEST"
// Add the user
IF HAddUser("MyConnection") = True THEN
Info("User added")
END
Syntax
<Result> = HAddUser(<Connection>)
<Result>: Boolean
  • True if the user was added,
  • False if an error occurred. HError is used to identify the error.
<Connection>: Character string or Connection variable
Connection for which a user must be added. This connection corresponds to:
Remarks

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 HInfoServerRights and HModifyServerRights.

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 9
This page is also available for…
Comments
METODO CREATE DATABASE HFSQL CLIENT/SERVER VIA WEBSERVICE COM DIRETIVAS OK
https://forum.pcsoft.fr/fr-FR/pcsoft.br.windev/3252-informatica-novo-metodo-create-database-hfsql-client-server/read.awp
BOLLER
13 Jul. 2019

Last update: 02/01/2024

Send a report | Local help