Note
This variable is available starting with V2.2.77.
Description
validate_password_policy specifies the password validation policy.
Privilege requirements
Query variables
systenants and all user tenants can execute theSHOW VARIABLESstatement or query theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (MySQL mode) to view the values of global system variables.Modify variables
systenants can directly modify the values of global system variables.MySQL user tenants must have the
SUPERorALTER SYSTEMprivilege to modify the values of global system variables.Oracle user tenants must have the
ALTER SYSTEMprivilege to modify the values of global system variables.
Attributes
| Attribute | Description |
|---|---|
| Type | Enum |
| Default value | LOW |
| Value range | LOW: only the common password checks are performed.MEDIUM: the password length, number of uppercase letters, number of lowercase letters, number of digits, number of special characters, and whether the username and password are the same are checked. |
| Scope | Global |
| Modifiable | Yes. You can execute the SET statement to modify the value. |
Examples
Set the password validation policy to LOW, which performs only the common password checks.
obclient> SET GLOBAL validate_password_policy = 'LOW';
References
For more information about password complexity, see Password complexity.