Description
The validate_password_special_char_count variable specifies the minimum number of special characters in a user password.
Privilege requirements
Query variables
The
systenant and all user tenants can execute theSHOW VARIABLESstatement or view theSYS.TENANT_VIRTUAL_GLOBAL_VARIABLEview (in Oracle mode) or theinformation_schema.GLOBAL_VARIABLESview (in MySQL mode) to query the value of a global system variable.Modify variables
systenantThe
systenant can modify the value of a global system variable directly.MySQL user tenant
A MySQL user tenant needs the
SUPERorALTER SYSTEMprivilege to modify the value of a global system variable.V4.x
In V4.x, Oracle user tenants need the
ALTER SYSTEMprivilege to modify the value of a global system variable starting from V4.2.0.
Attributes
| Attribute | Description |
|---|---|
| Type | uint |
| Default value | 0 |
| Value range | [0,2147483647] |
| Valid scope | GLOBAL |
| Modifiable | Yes. You can modify the value by using the SET statement. |