Resetting Forgotten Passwords | Teradata Vantage - 17.10 - Resetting Forgotten Passwords - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - Advanced SQL Engine Security Administration

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Administration
Security
Publication ID
B035-1100-171K
Language
English (United States)

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.