Home » Infrastructure » Windows » system ip
icon4.gif  system ip [message #157047] Tue, 31 January 2006 01:16 Go to next message
jaspreet30s
Messages: 11
Registered: January 2006
Junior Member
HI,
I have windows professional on my system and i am using oracle 9i.i have a database on which many user can log on can INSERT,UPDATE,DELETE so i want to keep a log of user and system ip from which the database was altered so i have want to get ip address of system from which the process is triggered
Re: system ip [message #157056 is a reply to message #157047] Tue, 31 January 2006 02:00 Go to previous message
vban2000
Messages: 207
Registered: March 2005
Senior Member
Hi

The following should give you the IP Address of the Client..

SELECT SYS_CONTEXT ('USERENV', 'IP_ADDRESS')
  FROM DUAL


Regards
AnDy
Previous Topic: connection to oracle 9i from ASP page OS is xp
Next Topic: Newbie - Install Oracle 9i on XP Home
Goto Forum:
  


Current Time: Thu Mar 28 12:36:43 CDT 2024