OraFAQ Forum: Windows

Home » Infrastructure » Windows » system ip

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

system ip [message #157047]

Tue, 31 January 2006 01:16

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

Report message to a moderator

Re: system ip [message #157056 is a reply to message #157047]

Tue, 31 January 2006 02:00

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 22 04:33:15 CST 2024