Oracle Auditing
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle Auditing

  1. #1
    Join Date
    Feb 2006
    Posts
    37

    Oracle Auditing

    Is there an Oracle AUDIT table that tracks the user's IP address from their terminal?


    v$session gives the machine, but the IP_address.

    Thanx

  2. #2
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,441

    Cool


    Did you check SYS_CONTEXT() function?
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

  3. #3
    Join Date
    Feb 2006
    Posts
    37
    not famaliar with this function.

    Please advise on how to call it.

  4. #4
    Join Date
    Jul 2002
    Location
    Lake Worth, FL
    Posts
    1,441

    Cool


    Easy, just check the manual
    "The person who says it cannot be done should not interrupt the person doing it." --Chinese Proverb

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