How Can I Configure a Password Expiration Policy?
You can set the global variable password_effect_time to control the default validity period of a user password.
You can change the value of the password_effect_time parameter on the GaussDB console.
The value of password_effect_time indicates how many days until a password expires. The default value is 0, indicating that the created user password will never expire.