17.20 - Expired Password Effects on a Session - Analytics Database - Teradata Vantage

Teradata Vantage™ - Analytics Database Security Administration - 17.20

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-03-07
dita:mapPath
hjo1628096075471.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
zuy1472246340572

When a password expires, the system:

  • Allows an existing session for the user with the expired password to continue.
  • Allows the user to log on one session after the user password expires, if the logon string contains the correct expired password. The system limits the session to the MODIFY USER statement, to allow the user to establish a new password. After the user modifies the password, the system permits normal Analytics Database activity in the session.
  • Prevents access to the database when a user makes a second attempt to logon with an expired password.
  • Provides the following methods to update an expired password, depending on the application through which the user logs on:
    • Some applications prompt the user for a new password.
    • For applications that do not support password prompts, most allow the user to submit a MODIFY USER statement to create a new password.
    • For utilities such as MultiLoad that do not support MODIFY USER, the user must log off and log on again through a utility such as BTEQ that does support the statement.