Re: Oracle Auditing

From: John Hurley <>
Date: Mon, 22 Feb 2010 07:18:47 -0800 (PST)
Message-ID: <>

On Feb 22, 10:04 am, The Magnet <> wrote:


> Has anyone used some of the Oracle FGA?  We're needing to enable some
> auditing.  I'm having trouble getting it to work.  Reading all the
> documentation on this is taking a while as there are so many options.
> We're running 10g R2 Enterprise on CentOS.  We want to basically audit
> everything that 5 users do.  Can anyone help me with the command
> syntax for this?  I tried this to spool it to a file with no luck:
> ALTER SYSTEM SET audit_file_dest=/u05/NI00/audit;
> audit all by customer,product,data_holder,mutual_fund,orders by
> access;
> Thanks.

It would probably help if you supplied an error message.

Did you ever hear of putting single quotes around parameters when doing an alter system?

Lots of examples around the internet of how to do it ... Received on Mon Feb 22 2010 - 09:18:47 CST

Original text of this message