Re: E-mail alert DBA_AUDIT_TRAIL
Date: Wed, 10 Dec 2008 06:01:33 -0800 (PST)
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.
I now managed to create a user-defined metric in Enterprise Manager which does the trick (although there is some delay).
Matthias Received on Wed Dec 10 2008 - 08:01:33 CST