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. For operation details, see Modifying Parameters in a Parameter Template.

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.