RE: finding ip address of the connected sql session in database
- From: "Justin Cave \(DDBC\)" <jcave@xxxxxxxxxxx>
- To: <edwin_kodamala@xxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 21 Dec 2006 09:04:54 -0700
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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of edwin devadanam
Sent: Thursday, December 21, 2006 10:53 AM
To: oracle-l@xxxxxxxxxxxxx; edwin_kodamala@xxxxxxxxx
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
Other related posts:
