Tracking Password Changes | Teradata Vantage - 17.20 - Tracking Changes to Passwords - 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

The DBC.DBase table stores the date and time a password was last changed by a user.

Query the DBC.UsersV view, which references the DBC.DBase table and other system tables, selecting the columns PasswordLastModDate and PasswordLastModTime, to see the latest activities against passwords, for example:

SELECT UserName, PasswordLastModDate, PasswordLastModTime FROM DBC.Users;

Result:

 *** Query completed. 6 total rows found. 3 columns returned.
 *** Total elapsed time was 1 second.
UserName               PasswordLastModDate  PasswordLastModTime
---------------------  -------------------  -------------------
DBC                               07/06/25             12:15:27
TDPUSER                           07/06/25             12:24:25
SystemFe                          07/06/25             12:24:31
SysAdmin                          07/06/25             12:24:31
Crashdumps                        07/06/25             12:29:01
Sys_Calendar                      07/06/25             12:29:0