ONLINE HELP
 WINDEVWEBDEV AND WINDEV MOBILE

Exclusive WINDEV, WEBDEV and WINDEV Mobile Subscription (Update 3) new feature. See "Using new features exclusive to a subscription-based version in a project".
Help / WLanguage / Managing databases / HFSQL / Managing HFSQL Client/Server
  • Overview
  • Password management policy in the HFSQL Control Center
  • Enabling a password management policy
  • Setting user passwords
  • Server dashboard: "Security audit" widget
  • Implementing a password management policy programmatically
WINDEV
WindowsLinuxJavaReports and QueriesUser code (UMC)
WEBDEV
WindowsLinuxPHPWEBDEV - Browser code
WINDEV Mobile
AndroidAndroid Widget iPhone/iPadIOS WidgetApple WatchMac Catalyst
Others
Stored procedures
Overview
To manipulate data in an HFSQL Client/Server database, users need to authenticate using login credentials.
You can now implement a password security policy to define how long and how complex passwords should be, and how often they should be renewed (e.g. passwords must be changed every month).
This policy can be defined and modified:
Password management policy in the HFSQL Control Center

Enabling a password management policy

To enable the various password management policy options:
  1. Open the HFSQL Control Center.
  2. Connect (if necessary) to an HFSQL server. For more details, see Managing HFSQL Client/Server databases.
  3. Double-click the name of HFSQL server in the tree structure.
  4. In the ribbon, click "Server configuration".
  5. In the configuration window, click "Password security". The window that appears shows the available options to implement a password security policy.

Setting user passwords

When creating or editing a user in the HFSQL Control Center, you can set or change the user's password.
If the password management policy has been activated, password size and complexity criteria are automatically applied when a user is created.

Server dashboard: "Security audit" widget

In the HFSQL Control Center dashboard, the "Security audit" widget shows whether one or more users have expired passwords to connect to the server.
Implementing a password management policy programmatically
To implement the password management policy in WLanguage:
  1. Create a variable of type hSecurityPolicy. Define the values of the associated properties.
  2. Enforce the password management policy with HSecurityPolicySet.
Several functions are available to manage the password management policy:
Subscription-exclusive new feature
HSecurityPolicyCheck
Checks that each user accounts complies with the password security policy associated with the HFSQL server.
Subscription-exclusive new feature
HSecurityPolicyGet
Gets the security policy of an HFSQL server.
Subscription-exclusive new feature
HSecurityPolicySet
Sets the password security policy of an HFSQL server.
Subscription-exclusive new feature
HSecurityPolicyUnlockAccount
Unlocks a user account that has been locked due too many unsuccessful login attempts.
Minimum version required
  • Version 2025 (Subscription)
This page is also available for…
Comments
Click [Add] to post a comment

Last update: 07/16/2025

Send a report | Local help