Re: How to log attempts to connect as a locked user account
Date: Tue, 04 Aug 2009 09:33:15 +0200
chet justice schrieb:
> Since you are just de-commissioning these databases, why go through the
> auditing process at all. Just set up a trigger and have it send you an
> email everytime someone tries to connect. Might be easier than going in
> randomly to query the audit trail.
> I tried to do something similar here:
That was nearly exactly what I did need, but I had to do it for a 9i database. There's no utl_mail available, but utl_smtp does its job very well, just few lines more to type. :)
That's what I have done in detail:
Thanks to all of you, folks!
-- Usn's IT Blog for Linux, Oracle, Asterisk http://www.usn-it.de -- http://www.freelists.org/webpage/oracle-lReceived on Tue Aug 04 2009 - 02:33:15 CDT