Re: E-mail alert DBA_AUDIT_TRAIL

On Dec 10, 1:26 pm, gazzag <gar..._at_jamms.org> wrote:
> 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

I now managed to create a user-defined metric in Enterprise Manager which does the trick (although there is some delay).

Thanks
Matthias Received on Wed Dec 10 2008 - 08:01:33 CST