In Teradata, there is a way to view the reason that a username is not authenticating. Teradata is good about collecting information at the time of authentication. It can be verified, when an error like “Error: Logon failed!” occurs, if it is something like a bad password, or if the account is locked.
select cast(cast(logdate as format 'YYYY-MM-DD') as varchar(100)) ,cast(logtime as varchar(100)) ,username ,cast(cast(logondate as format 'YYYY-MM-DD') as varchar(100)) ,cast(logontime as varchar(100)) ,ClientIpAddress ,ClientProgramName ,ClientSystemUserId ,event from dbc.logonoff where logdate >= date '2016-12-01' and event not in ('Logon','Logoff') order by 1 desc, 2 desc
More columns can be added to the query with good information. To view all the information that can called from the “dbc.logonoff” view: “help view dbc.logonoff“