Password Expiration

User profiles control how often users must change their passwords. Initially, the DEFAULT profile is set so that passwords never expire.

Important: Password expiration has no effect on any of the user's current sessions.

Set Password Expiration and Grace Period

You can change the default value to set a password expiration. Alternatively, you can create additional profiles that set time limits for passwords and assign users to them.

When a password expires, the user must change the password on the next login. However, you can set a PASSWORD_GRACE_TIME in any individual user's profile, allowing that user to log in after the expiration. After the password expires, Vertica issues a warning about the password expiration but continues to recognize the password.

After the grace period ends, users must change their passwords to log in, unless they have changed them already in response to the warning.

Expire a Password

You can expire a user's password immediately using the ALTER USER statement's PASSWORD EXPIRE parameter. By expiring a password, you can: