OraFAQ Forum: Security » Find IP Addresses

Home » RDBMS Server » Security » Find IP Addresses

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

Find IP Addresses [message #225141]

Sun, 18 March 2007 06:59

reehan
Messages: 4
Registered: November 2005
Location: Pakistan

Junior Member

can anybody tell me that if someone insert,delete,update record in oracle database, his IP address saved in the database automatically, or there is any monitoring tool for this, plz help me in this regard,

Background for asking this query is!
I'm Oracle Developer in a Textile Mill and there are many departments i'm handling. Last week aaccounts department delete or insert some records of Store Department's database unauthentically. And now i have no prrof of this situation. So because i'm asking u and worried.

Report message to a moderator

Re: Find IP Addresses [message #225153 is a reply to message #225141]

Sun, 18 March 2007 09:45

Michel Cadot
Messages: 68712
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No.
Yes: AUDIT

Have a look at:
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_4007.htm
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/initparams016.htm#sthref91
http://download-uk.oracle.com/docs/cd/B19306_01/server.102/b14237/statviews_3056.htm#sthref1953

You don't have IP but you have host and terminal names and then can convert them using utl_inaddr.get_host_address.

Regards
Michel

Report message to a moderator

Re: Find IP Addresses [message #261013 is a reply to message #225153]

Tue, 21 August 2007 09:24

kafaween
Messages: 7
Registered: August 2007
Location: Jordan

Junior Member

Hi

Yes you can know the IP after login using webutil

webutil_clientinfo.get_ip_address;

see

http://www.oracle.com/webapps/online-help/forms/10g/state/content/navId.3/navSetId._/vtTopicFile.web_util%7Cinstall~htm/

metalink document Note:403192.1

best regards;

Report message to a moderator

Previous Topic:	OS login
Next Topic:	ORA-01031: insufficient privileges

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Nov 13 03:19:38 CST 2024