The PasswordReuse parameter defines a time span during which a user cannot reuse a previously used password.
When a user changes a password, Teradata Database records the old password and the current date. The next time the user attempts to change the password, Teradata Database compares the new password to the current password.
- If they are equal, the system rejects the new password.
- If they are not equal, the system searches the list of old (expired) user passwords for a password equal to the proposed password. If the system finds a match and the number of days between the last password modify date and the current date is less than the PasswordReuse setting, Teradata Database does not allow the password change.
The system tracks expired passwords for the duration of the PasswordReuse setting.