finding ip address of the connected sql session in database

  • From: edwin devadanam <edwin_kodamala@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx, edwin_kodamala@xxxxxxxxx
  • Date: Thu, 21 Dec 2006 07:53:21 -0800 (PST)

Hi,
   
  Is there a way to find IP address of the connected sql sessions of the 
database.
   
   
  Ex:
  We are not going restrict IP address completely, we want restrict programs 
running by user based on IP address.

ex: Users Accessing oracle from MSAccess should use only citrix not their 
desktop or any other tools.

  Any help would be appreciated.
   
  Thanks,
  Edwin.k

 __________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 

Other related posts: