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: Capture SQL for selected users

Re: Capture SQL for selected users

From: ghm <ghm_at_dslextreme.com>
Date: Sun, 21 Nov 2004 10:50:53 -0800
Message-ID: <10q1ond9j41kvee@corp.supernews.com>

"DA Morgan" <damorgan_at_x.washington.edu> wrote in message news:1101018245.916346_at_yasure...
> ghm wrote:
>
> > Is it possible without creating triggers on every table in my database
to
> > capture all DDL/DML (excluding SELECT) for selected users? For audit
> > purposes, I need to capture the SQL for certain users only.
> >
> > Thanks in Advance
>
> Depends on whether your intent is Sarbanes-Oxley complaince. If that is
> the point of your request you need to state that as well as the Oracle
> version and edition.
> --

I have both 8.1.7.4 and 9.2.0.2 to deal with. It is not for Sarbanes-Oxley compliance but if you have a solution that is dependent on it being for Sarbanes-Oxley, then yes. Received on Sun Nov 21 2004 - 12:50:53 CST

Original text of this message

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