16.10 - Resetting Forgotten Passwords - Teradata Database

Teradata Database Security Administration

prodname
Teradata Database
vrm_release
16.10
created_date
June 2017
category
Administration
Security
featnum
B035-1100-161K

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
    FOR USER;

The example MODIFY USER statement replaces the forgotten password with mysecret, and the FOR USER specification causes the system to reset the value for the global PasswordChgDate parameter in the DBC system table to zero. The zero value then causes the existing password to expire at the next logon.

A non-zero profile value supersedes the corresponding global value.

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.