Oracle Audit

Hi,
I'd like to Audit log the tasks performed by all users with the exception of 3 schema.
I need to enable the audit on file system in my database oracle 11.2.0.3.0 for 64-bit Windows for all users except for 3 schema (TOM, SAM; SCOTT) , to do this I thought to activate the AUDIT_TRAIL, but I need to know what are the steps.

below the current configuration of my db:

select *
from v$parameter
where name like '%audit%';


NAME: audit_file_dest
VALUE: C:\ORACLE\ADMIN\PR\ADUMP
DISPLAY_VALUE: C:\ORACLE\ADMIN\PR\ADUMP
ISDEFAULT: FALSE
ISSES_MODIFIABLE: FALSE
ISSYS_MODIFIABLE: DEFERRED
ISMODIFIED: FALSE  

NAME: audit_trail
VALUE: DB
DISPLAY_VALUE: DB
ISDEFAULT: FALSE
ISSES_MODIFIABLE: FALSE
ISSYS_MODIFIABLE: FALSE
ISMODIFIED: FALSE

Could someone tell me what are the steps to enable the privilege auditing SELECT, INSERT, UPDATE, DELETE on file?

Thanks in advance!
ralph_reaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Praveen Kumar ChandrashekatrDatabase Analysist Senior Commented:
0
sventhanCommented:
You should use extended DB auditing.

Just place the following line in parameter file

audit_trail = db_extended.

This parameter will enable recording of SQL text and values of  the bind variables, if used, in the columns.

If you want more fine grained data access auditing you should use Virtual private database.

Check out these...

http://www.datadisk.co.uk/html_docs/oracle/fgda.htm

http://www.oracle-base.com/articles/10g/database-security-enhancements-10g.php
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.