DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: security issue

  1. #1
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639

    security issue

    Hi,

    Is there a way to capture information about the user's IP Address
    who access (DML) a databse table? Especially when it is on a 3-tier
    set-up?(web based client -> Apps server -> DB server)

    Thsnk you all

  2. #2
    Join Date
    Aug 2001
    Location
    chennai,bangalore
    Posts
    840
    U can know the m/c name from where the SQL is coming.
    table v$session ,column is machine

    regards
    anandkl
    anandkl

  3. #3
    Join Date
    May 2001
    Location
    San Francisco, California
    Posts
    511
    Use sys_context in a database trigger to capture ip_address.
    Remember the Golden Rule - He who has the gold makes the rules!
    ===================
    Kris109
    Ph.D., OCP 8i, 9i, 10g, 11g DBA

  4. #4
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    thanks friends,

    is sys_context found in v$session?

  5. #5
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    does ure end user pc connect directly to the db, otherwise all you will get is the ip address of the app server

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