We have a teradata user name READQ using which we connect to the QA environment.
Recently someone locked this user. Any query to trace from any of the system tables avaiable as to from which login id this was locked?
Your help is higly appreciated.
SELECT * FROM dbc.LogonOffV
WHERE Event = 'Bad Password'
AND USERNAME = 'READQ'
ORDER BY LogDate DESC, LogTime DESC;
Depending on your Teradata release you might look at:
LogonSource, ClientIpAddress, ClientSystemUserId