17.10 - Using MODIFY USER to Replace an Expired Password - 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)

Use the following SQL statement to establish a new password:

    MODIFY USER username AS PASSWORD = passwordname;

The password is immediately valid for the number of days indicated in the ExpirePassword field of the DBC.SysSecDefaults table.

For details, see the MODIFY USER syntax in Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144.