Oracle Auditing

From: The Magnet <>
Date: Mon, 22 Feb 2010 07:04:39 -0800 (PST)
Message-ID: <>

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. Received on Mon Feb 22 2010 - 09:04:39 CST

Original text of this message