PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US

  • Rights required to add a user
  • Managing rights
  • "SuperUser" user
WINDEV
WindowsLinuxUniversal Windows 10 AppJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadApple WatchUniversal Windows 10 AppWindows Mobile
Others
Stored procedures
Adds a user to a database. All the characteristics of the user must be entered in the variables for user management.
Versions 17 and later
iPhone/iPad This function is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This function is now available for the iPhone/iPad applications.
iPhone/iPad This function is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This function is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This function is now available in Windows Store apps mode.
Universal Windows 10 App This function is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Universal Windows 10 App This function is now available in Universal Windows 10 App mode.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 22 and later
Android Widget This function is now available in Android Widget mode.
WINDEV MobileAndroid This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
New in version 22
Android Widget This function is now available in Android Widget mode.
WINDEV MobileAndroid This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
Android Widget This function is now available in Android Widget mode.
WINDEV MobileAndroid This function is now available for the Android applications.
WINDEVJava This function is now available for the Java applications.
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 Name>)
<Result>: Boolean
  • True if the user was added,
  • False if an error occurred. HError is used to identify the error.
<Connection Name>: Character string (with or without quotes)
Name of the connection for which a user must be added. This connection was defined in the data model editor, or by HDescribeConnection or HOpenConnection.
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.

Managing rights

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:
See Managing the rights in HFSQL Client/Server for more details.

"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.
This variable is taken into account from version 90033 of the HFSQL Server.
Components
WINDEVWEBDEV - Server code wd230hf.dll
Windows Mobile wp230hf.dll
Java wd230java.jar
Linux wd230hf.so
Android wd230android.jar
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment