Re: Log user account lockouts

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 16 Mar 2006 17:34:29 +0100
Message-ID: <44199395$0$27084$626a54ce@news.free.fr>

"mikaelkruse" <mikaelkruse_at_hotmail.com> a écrit dans le message de news: 1142496456.179866.36970_at_i39g2000cwa.googlegroups.com...
| Yes I could check dba_users recurringly. But this would mean checking
| after the actual event, also dba_users only provide date, no time. I
| would prefer to log it every time it actually happens, when it actually
| happens. But maybe this is asking too much of Oracle...
|

I don't think lock happens untill a user tries to connect (but actually didn't check it).
You can add a trigger on servererror to trap the error when user tries to connect.

Regards
Michel Cadot Received on Thu Mar 16 2006 - 10:34:29 CST