Audit_trail=OS, trying to caputre SELECT
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: Audit_trail=OS, trying to caputre SELECT

  1. #1
    Join Date
    May 2007
    Posts
    6

    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

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    look at dbms_fga

  3. #3
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    The standard database auditing does not captures the entire statement. It just informs that someone have performed select on that table

    Regards

  4. #4
    Join Date
    May 2007
    Posts
    6
    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.

  5. #5
    Join Date
    May 2003
    Posts
    46

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width