17.10 - Handling Password Expiration - Call-Level Interface Version 2

Teradata® Call-Level Interface Version 2 Reference for Workstation-Attached Systems

Product
Call-Level Interface Version 2
Release Number
17.10
Release Date
October 2021
Content Type
Programming Reference
Publication ID
B035-2418-061K
Language
English (United States)

When the application sends out the logon request with an expired password, a conditional session is established with the database. The only Teradata SQL action that the application can take is to submit a MODIFY USER statement that assigns a new password to the user.

If a logon is attempted for a user with an expired password, and if there is already a session logged on for that user, the logon attempt receives a failure notification and the session is not established.