Find which logon id locked the user

Database

Find which logon id locked the user

Hi there,

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.

Regards

John

3 REPLIES
N/A

Re: Find which logon id locked the user

Hi John,

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

Re: Find which logon id locked the user

Brilliant diater...Thank you so much..

Re: Find which logon id locked the user

Thank you.. Really helps much :)