Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Auditing DML of selected users

Re: Auditing DML of selected users

From: George Mansoor <ghm_at_4link.net>
Date: Mon, 3 May 2004 01:06:14 -0700
Message-ID: <109bv31skuegc64@corp.supernews.com>


Pete - Thanks for the information. I just don't get how to audit insert/update/delete on all tables for just a few users and get the DML statement for that insert/update/delete. Is this possible w/ auditing, or do I need to install triggers on every table?

Thanks

George

"Pete Finnigan" <plsql_at_petefinnigan.com> wrote in message news:60aiXyAznTjARxfw_at_peterfinnigan.demon.co.uk...
> Hi
>
> You can use audit, have a look at a paper I wrote last year called "An
> introduction to simple Oracle auditing" it is available from my site at
> http://www.petefinnigan.com/orasec.htm
>
> kind regards
>
> Pete
> --
> Pete Finnigan
> email:pete_at_petefinnigan.com
> Web site: http://www.petefinnigan.com - Oracle security audit specialists
> Book:Oracle security step-by-step Guide - see http://store.sans.org for
details. Received on Mon May 03 2004 - 03:06:14 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US