|
|
|
|
|
|
|
|
- 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?
Managing the groups and users (HFSQL Client/Server)
 Available only with this kind of connection
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.
Variables for managing users Which variables? The following variables are used to manage users: | | | HUser.ActiveDirectory | Boolean (False by default).
If this variable is set to True, the user is using an authentication via Active Directory. | | 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.CreationInfo | Read-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. | | HUser.Description | Character string.
User description. | | HUser.Email | Character string.
Email address of user. | | HUser.EnabledAccount | Boolean (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.ExpirationDate | Read-only date.
Password expiration date. This date is deduced from the validity period of password and from the date of its last modification. | | HUser.FullName | Character string.
Full name of user (up to 50 characters). | | HUser.Groups | Character string.
Name of groups to which the user is associated. The different groups are separated by CR characters (Carriage Return). | | HUser.Login | Character string
User login (up to 50 characters).
The user login is not case sensitive. | | HUser.Password | Read-only character string.
User password. This password is sensitive to the case and to the accented characters. | | HUser.Phone | Character string.
User's phone number. | | HUser.Photo | Binary string corresponding to the photo of user.
We recommend that you use dSaveImagexxx to assign an image to this variable. | | HUser.SuperUser | Boolean (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.ValidityPeriod | Integer (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. |
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: - Username: Admin
- Password: "" (empty string)
- User defined as super-user
Variables for managing groups The following variables are used to manage groups of users: | | | HGroup.ActiveDirectory | Boolean (False by default).
If this variable is set to True, the group is using an authentication via Active Directory. | | 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.Description | Character string.
Group description. | | HGroup.Name | Character string.
Name of the group (up to 50 characters). | | HGroup.Users | Character 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:
This page is also available for…
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|