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.