<div>
Thanks a lot for the info and tips. <br />
sdstuber--Back to &quot;for example 1017 would indicate the user logged in with the wrong password &quot;. which error number corresponds to locked account?
</div>


<div>
sdstuber --Thanks a lot for the code. &nbsp;In 12c unified auditing some views and tables have been changed. However the idea is good. Appreciate it.
</div>


<div>
Not sure what information is looking to be gathered, but most information is available in the dbevent trigger. &nbsp;User you tried to log in as, where they came from, time, program, etc. &nbsp;We used it quite a bit.
</div>


<div>
Very sorry I did not realize that the question was not closed.
</div>


<div>
Thanks a lot for everyone's tip/help.
</div>


<div>
Please close it for you. I tried very hard to close it, but failed.
</div>


<div>
Please close it for me. <br />
sdstuber should get more than a half of points. The other users split the rest.
</div>


<div>
<div class="content wysiwyg-content">
Want to implement the following.<br />
When the user tries to login, enters the wrong passwords, and the account is logged, it will notify a DBA about the locking account? If we can trigger in the right moment, the notification part is easy to implement. <br />
<br />
I need some idea how and where to implement the trigger or similar thing ASAP? &nbsp; <br />
If any guru can shed some light on it (links or just ideas), I will greatly appreciate it.
</div>
</div>


Want to implement the following.
When the user tries to login, enters the wrong passwords, and the account is logged, it will notify a DBA about the locking account? If we can trigger in the right moment, the notification part is easy to implement. 

I need some idea how and where to implement the trigger or similar thing ASAP?   
If any guru can shed some light on it (links or just ideas), I will greatly appreciate it.

Trigger for checking account lock

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.