Audit_trail=OS, trying to caputre SELECT

Hi Guys,
I'm new to oracle and trying to explore some database audit options, I've doen the following:

set audit_trail=OS
set audit_sys_operations=true

then I run "audit select table by USER1"

But when I'm doing any SELECT by connection USER1, I'm not getting the complete SELECT statment in the audit files under dump location.

Following is contents of the audit file:


SESSIONID: "11745" ENTRYID: "13" STATEMENT: "9" USERID: "USER1" USERHOST: "server123" TERMINAL: "pts/16" ACTION: "103"
RETURNCODE: "0" OBJ$CREATOR: "SYS" OBJ$NAME: "V$INSTANCE" SES$ACTIONS: "---------S------" SES$TID: "4294951066" OS$USERID: "or
acle"



Please help me to do it.

Thanks,
Hussain

look at dbms_fga

The standard database auditing does not captures the entire statement. It just informs that someone have performed select on that table

Regards

Bore, thanks for the update.

Is there a way in a READ ONLY mode database, how can I capture the SELECT statments?

Thanks in advance.

Use FGA:

http://www.oracle.com/technology/ora...nanda_fga.html