Re: Audit software for Oracle

From: Howard J. Rogers <howardjr_at_www.com>
Date: Thu, 21 Jun 2001 19:46:50 +1000
Message-ID: <3b31c2c0@news.iprimus.com.au>

How about not switching on that sort of auditing (which will cripple performance on the entire database, and in any event doesn't tell you preciely *what* the Users updated or deleted), and instead get into the habit of analyzing your redo logs with the log miner packages?

Shows you exactly what a user did, when they did it, and even what SQL you'd have to issue to reverse the awfulness of what they did.

Best of all, it's entirely free. Provided you are running 8.1.x, of course.

Regards
HJR "John Theunis" <john.theunis_at_advalvas.be> wrote in message news:9go68h$69o$1_at_news.worldonline.be...
> hi,
>
> how about the Oracle auditing itself?
> you can audit db events, user stuff, object stuff...
>
> regards,
> john
>
>
> "Wayne Balmer" <wbalmery_at_yahoo.com> wrote in message
> news:0vLX6.1064$Tt6.423170_at_monger.newsread.com...
> > Does anyone know of any Auditing software for Oracle that can keep an
audit
> > trail or activity log of individual users?
> >
> > Thanks,
> >
> > Wayne Balmer
> >
> >
>
>
Received on Thu Jun 21 2001 - 04:46:50 CDT