PC SOFT

ONLINE HELP
FOR WINDEV, WEBDEV AND WINDEV MOBILE

Home | Sign in | English US
  • Overview
  • Variables for managing users
  • Which variables?
  • When should I use these variables?
  • Default user
  • Variables for managing groups
  • When should I use these variables?
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
Overview
To simplify the management of users and groups of users, the HFSQL Client/Server engine is using several variables allowing you to easily define the characteristics of groups and users.
Note: From version 19, HFSQL is the new name of HyperFileSQL.
Versions 17 and later
iPhone/iPad This feature is now available for the iPhone/iPad applications.
New in version 17
iPhone/iPad This feature is now available for the iPhone/iPad applications.
iPhone/iPad This feature is now available for the iPhone/iPad applications.
Versions 18 and later
Universal Windows 10 App This feature is now available in Windows Store apps mode.
New in version 18
Universal Windows 10 App This feature is now available in Windows Store apps mode.
Universal Windows 10 App This feature is now available in Windows Store apps mode.
Versions 21 and later
Universal Windows 10 App This feature is now available in Universal Windows 10 App mode.
New in version 21
Universal Windows 10 App This feature is now available in Universal Windows 10 App mode.
Universal Windows 10 App This feature is now available in Universal Windows 10 App mode.
Versions 22 and later
Android Widget This feature is now available in Android Widget mode.
Android This feature is now available for the Android applications.
Java This feature is now available for the Java applications.
New in version 22
Android Widget This feature is now available in Android Widget mode.
Android This feature is now available for the Android applications.
Java This feature is now available for the Java applications.
Android Widget This feature is now available in Android Widget mode.
Android This feature is now available for the Android applications.
Java This feature is now available for the Java applications.
Variables for managing users

Which variables?

The following variables are used to manage the users:
Versions 23 and later
HUser.ActiveDirectory
New in version 23
HUser.ActiveDirectory
HUser.ActiveDirectory
Boolean (False by default).

If this variable is set to True, the user is using an authentication via Active Directory.
HUser.EnabledAccountBoolean (True by default).

If this variable is set to False, the account exists but it is not enabled. Used for example to disable a user account during a given period.
HUser.ExpirationDateRead-only date.

Expiration date of password. This date is deduced from the validity period of password and from the date of its last modification.
HUser.DescriptionCharacter string.

User description.
HUser.ValidityPeriodInteger (0 by default, no validity period).

Validity period of password (in days). This validity period is taken into account from the date of last password modification.
HUser.EmailCharacter string.

Email address of user.
HUser.GroupsCharacter string.

Name of groups to which the user is associated. The different groups are separated by CR characters (Carriage Return).
HUser.CreationInfoRead-only character string.

Name of person who created the user account and creation date.

These details are separated by a tabulation (TAB). The creation date corresponds to an 8-digit character string.
Versions 18 and later
HUser.AuthorizedIP
New in version 18
HUser.AuthorizedIP
HUser.AuthorizedIP
Character string

Set of elements representing the IP addresses allowed for the user. The different elements are separated by CR characters (Carriage Return).
This variable can correspond to:
  • An IPv4 address (68.12.53.26 for example) or several IPv4 addresses separated by CR characters (Carriage Return).
  • An IPv6 address (feco::40 for example) or several IPv6 addresses separated by CR characters (Carriage Return).
  • A range of IPv4 addresses in CIDR format. For example: 68.12.0.0/16
  • A range of IPv6 addresses in CIDR format. For example: fec0:56::0/32
  • A DNS FQDN name (myserver.pcsoft.com for example) or several DNS names separated by CR characters (Carriage Return).
  • A sub-domain name (.pcsoft.com for example: pay attention to the dot) or several sub-domain names separated by CR characters (Carriage Return).
HUser.LoginCharacter string

User login (up to 50 characters).

The user login is not case sensitive.
HUser.PasswordRead-only character string.

User password. This password is sensitive to the case and to the accented characters.
HUser.FullNameCharacter string.

Full name of user (up to 50 characters).
HUser.PhotoBinary string corresponding to the photo of user.

We recommend that you use dSaveImagexxx to assign an image to this variable.
HUser.SuperUserBoolean (False by default)

If this variable is set to True:
  • The rights granted to this user are not checked. Therefore, all the actions can be performed by this user.
  • The password of this user never expires.
HUser.PhoneCharacter string.

Phone number of user.

When should I use these variables?

The variables for user management are used:

Default user

By default, the following user is automatically created when using a Client/Server database:
  • Login: Admin
  • Password: "" (empty string)
  • User defined as super-user
Variables for managing groups
The following variables are used to manage the groups of users:
Versions 23 and later
HGroup.ActiveDirectory
New in version 23
HGroup.ActiveDirectory
HGroup.ActiveDirectory
Boolean (False by default).

If this variable is set to True, the group is using an authentication via Active Directory.
HGroup.DescriptionCharacter string.

Group description.
Versions 18 and later
HGroup.AuthorizedIP
New in version 18
HGroup.AuthorizedIP
HGroup.AuthorizedIP
Character string

Set of elements representing the IP addresses authorized for the group. The different elements are separated by CR characters (Carriage Return).
This variable can correspond to:
  • An IPv4 address (68.12.53.26 for example) or several IPv4 addresses separated by CR characters (Carriage Return).
  • An IPv6 address (feco::40 for example) or several IPv6 addresses separated by CR characters (Carriage Return).
  • A range of IPv4 addresses in CIDR format. For example: 68.12.0.0/16
  • A range of IPv6 addresses in CIDR format. For example: fec0:56::0/32
  • A DNS FQDN name (myserver.pcsoft.com for example) or several DNS names separated by CR characters (Carriage Return).
  • A sub-domain name (.pcsoft.com for example: pay attention to the dot) or several sub-domain names separated by CR characters (Carriage Return).
HGroup.NameCharacter string.

Name of the group (up to 50 characters).
HGroup.UsersCharacter string.

List of users associated with the group. The names of users are separated by CR characters (Carriage Return).

When should I use these variables?

The variables for group management are used:
Minimum required version
  • Version 9
This page is also available for…
Comments
Click [Add] to post a comment