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.