-
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
-
-
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.
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|