If a user forgets his or her password, you can replace the forgotten password using the MODIFY USER statement:
MODIFY USER JDoe AS PASSWORD = mysecret;
The example MODIFY USER statement replaces the forgotten password with mysecret.
When the MODIFY USER statement resets the forgotten password to a temporary password, the system does not update the DBC.OldPasswords table or verify the temporary password against password reuse rules.
Do not lose the password for user DBC. The system can lock out user DBC if it exceeds the MaxLogonAttempts setting, and only user DBC can modify the user DBC password. If this lockout occurs, contact Teradata Support Center to unlock DBC.