Re: How to force a Teradata user to modify his/her password on next login?
The FOR USER option effectively established a temporary password that can be used to logon one time by the user. This option is only effective if the ExpirePassword attribute (set in DBC.SysSecDefaults or a profile) is set to a value greater than 0.
MODIFY USER RobertSmith AS PASSWORD = secret FOR USER;
The existing password immediately expires and is replaced by “secret”. In this example, “secret” is effectively a temporary password that allows a one-time logon. The value for PasswordChgDate is reset to 0.
Note: The PasswordChgDate column is also set to 0 when a new user is created – assuming that ExpirePassword is set to a value greater than 0.
The temporary password expires immediately when the user logs on for the first time and the user needs to select a new, permanent password at that time.