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
Published
July 2021
Language
English (United States)
Last Update
2022-02-15
dita:mapPath
ppz1593203596223.ditamap
dita:ditavalPath
wrg1590696035526.ditaval
dita:id
zuy1472246340572

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.