Re: E-mail alert DBA_AUDIT_TRAIL

From: gazzag <gareth_at_jamms.org>
Date: Wed, 10 Dec 2008 04:26:41 -0800 (PST)
Message-ID: <daf81dd1-145c-4fdf-a9c3-c4c33a9fae43@w1g2000prk.googlegroups.com>


On 10 Dec, 10:08, matthias.h..._at_gmail.com wrote:
> Hello,
>
> Oracle 10g 10.2.0.4 on Linux.
>
> I enabled some auditing of events to the sys.aud$ table (audit_trail =
> DB_EXTENDED).
> Is it possible to configure some sort of e-mail alerting so I receive
> a mail when new information is added to the sys.aud$ table ? Should I
> create a trigger on this table or is this not supported by Oracle ?
>
> Thanks
> Matthias

I'd have to check but I seem to recall that creating triggers on SYS objects is not supported.

-g Received on Wed Dec 10 2008 - 06:26:41 CST

Original text of this message