RE: finding ip address of the connected sql session in database

You can get the IP address of the client machine for the current session with the function  

sys_context('USERENV','IP_ADDRESS')  

Note that trying to restrict what programs users can use tends to be a rather difficult proposition. A user can trivially change the program that Oracle sees simply by renaming the executable on their client machine. If the goal here is to prevent a user from accidentally using a local version of a particular tool or to prevent a user from accidentally logging in to the production database rather than the reporting database with certain reporting tools, restricting connections from particular programs might work reasonably well. If the goal here is to provide real security against, say, a rogue employee downloading reams of sensitive information into a local Access database that they can sell on the black market, this sort of restriction is probably not going to be particularly effective.  

Justin Cave  

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of edwin devadanam Sent: Thursday, December 21, 2006 10:53 AM To: oracle-l_at_freelists.org; edwin_kodamala_at_yahoo.com Subject: finding ip address of the connected sql session in database  

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

--
http://www.freelists.org/webpage/oracle-l