Re: E-mail alert DBA_AUDIT_TRAIL

On Dec 10, 1:26 pm, gazzag <gar...@xxxxxxxxx> wrote:
On 10 Dec, 10:08, matthias.h...@xxxxxxxxx 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
.

Relevant Pages

  • Re: oldest American skull found!
    ... > Trigger was a horse, you dummy, not his great aunt. ... It's sort of like the bone reliquiae of various saints on ... > display in churches and museums all over Italy. ... > important enough to have his/hers bones displayed in a museum. ...
    (sci.archaeology)
  • Re: oldest American skull found!
    ... > Trigger was a horse, you dummy, not his great aunt. ... It's sort of like the bone reliquiae of various saints on ... > display in churches and museums all over Italy. ... > important enough to have his/hers bones displayed in a museum. ...
    (sci.anthropology)
  • Re: oldest American skull found!
    ... > Trigger was a horse, you dummy, not his great aunt. ... It's sort of like the bone reliquiae of various saints on ... > display in churches and museums all over Italy. ... > important enough to have his/hers bones displayed in a museum. ...
    (sci.anthropology.paleo)
  • Re: Sony KV27S15 died
    ... I did resolder the transformers so if that caused the original ... It's hard to say with this sort of thing, there can be a lot of different ... events which can trigger a catastrophic chain reaction failure. ...
    (sci.electronics.repair)
  • RE: SQL operation in Server Explorer differ from Enterprise Manager
    ... Provider for ODBC you will see the same behavior as in Enterprise Manager. ... In the scenario where multiple rows get updated by the trigger ODBC returns 1 record as being affected and OLE DB returns 3 records being affected. ...
    (microsoft.public.dotnet.languages.vb)