Re: Log user account lockouts

From: Michel Cadot <micadot{at}altern{dot}org>
Date: Thu, 16 Mar 2006 07:24:10 +0100
Message-ID: <4419048a$0$27081$626a54ce@news.free.fr>

"HansF" <News.Hans_at_telus.net> a écrit dans le message de news: pan.2006.03.15.21.56.07.115734_at_telus.net...
| On Wed, 15 Mar 2006 18:19:43 +0100, Michel Cadot wrote:
|
| >
| > "mikaelkruse" <mikaelkruse_at_hotmail.com> a écrit dans le message de news:
1142441831.231020.303180_at_u72g2000cwu.googlegroups.com...
| > | Hi,
| > | does anybody know a way to log when a user account is locked out? For
| > | instance when reaching FAILED_LOGIN_ATTEMPTS limit. The version is
| > | 8.0.6 (I know it's not that new..) I have searched documentation and
| > | forums, concerning eg auditing and system triggers, but without
| > | success. Help would be most appreciated..
| > |
| >
| > Ask your DBA to unlock the account.
| >
|
| I *think* the question is 'how do we automatically detect those
| lockouts?'
|
| /Hans

Ah yes! right, misread the question.

Maybe a job checking dba_users will do it.

Regards
Michel Cadot Received on Thu Mar 16 2006 - 00:24:10 CST