Home » RDBMS Server » Security » Find IP Addresses
Find IP Addresses [message #225141] Sun, 18 March 2007 06:59 Go to next message
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.
Re: Find IP Addresses [message #225153 is a reply to message #225141] Sun, 18 March 2007 09:45 Go to previous messageGo to next message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Find IP Addresses [message #261013 is a reply to message #225153] Tue, 21 August 2007 09:24 Go to previous message
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;
Previous Topic: OS login
Next Topic: ORA-01031: insufficient privileges
Goto Forum:
  


Current Time: Sat Dec 10 10:49:51 CST 2016

Total time taken to generate the page: 0.10016 seconds