Re: How to log attempts to connect as a locked user account

From: Martin Klier <>
Date: Tue, 04 Aug 2009 09:33:15 +0200
Message-ID: <>

Hi alltogether,

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!

Martin Klier

Usn's IT Blog for Linux, Oracle, Asterisk

Received on Tue Aug 04 2009 - 02:33:15 CDT

Original text of this message