Link to home
Start Free TrialLog in
Avatar of ralph_rea
ralph_rea

asked on

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!
SOLUTION
Avatar of Praveen Kumar Chandrashekatr
Praveen Kumar Chandrashekatr
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial