Re: Oracle Auditing

All true, but rather unnecessary since that sort of information is already recorded in the Redo Logs, of course.

And since things get logged in redo as part of normal database operations, there's zero overhead involved in generating the 'audit trail'.

Therefore, Log Miner (assuming Roland has version 8.1.x or above) is a useful auditing tool, without affecting performance unduly.

Of course, it won't audit operations which are performed 'nologging', but regular inserts, updates and deletes will be handled just fine.

Regards
HJR

--
Resources for Oracle: http://www.hjrdba.com
===============================


"Dale Shultz" <dfs001_at_yahoo.com> wrote in message
news:ceda5ef3.0111130924.967d61c_at_posting.google.com...


> Hi Roland,

>

> You can use row triggers to capture information such as which user is

> performing modifying the table, and before/after values of each of the

> columns.  Oracle's documentation included a long discussion on the use

> of triggers in auditing.

>

> I don't know if its possible to capture the exact SQL that was used to

> modify a table.

>

> O'Reilly has a good book on this topic:  "Oracle Security" by

> Theriault and Heney.

>

> - Dale Shultz

>

> "Meier Roland" <Roland_Meier_at_freesurf.ch> wrote in message

news:<9sqoko$45c$1_at_rex.ip-plus.net>...


> > Hello there

> >

> > I would like to audit insert, update and delete statemtens on a specific

> > table.

> >

> > Is it possible to see all the exact statements a user has processed on

this


> > table ? Can anyone tell me where I can see this.

> >

> > I am a little bit confused about the sys tables.

> >

> > Thank you very much

> >

> > Roland