Home » RDBMS Server » Security » Tracing computer ip address (Oracle , 10.1.2.0.2 , Win xp (pro) and Win 2003 Server)
Tracing computer ip address [message #333754] Mon, 14 July 2008 06:35 Go to next message
sd_md_rizwan@yahoo.com
Messages: 37
Registered: September 2007
Location: Saudi Arabia
Member

Hi all,
I have a created a user with user-name = abc and
password = xyz, and there are many computers under me who access the data of the user abc with the same user-name and password what i created, and now i want to know which computer is accessing the data, its ip address, its enter and exit time, and the queries executed (success or un-success) is it possible, if yes how, please give me the solution very clearly because I am a very beginner. Treat is as urgent
Thanks
Re: Tracing computer ip address [message #333803 is a reply to message #333754] Mon, 14 July 2008 08:30 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & follow Posting Guideline as stated above
Re: Tracing computer ip address [message #333833 is a reply to message #333754] Mon, 14 July 2008 09:29 Go to previous message
Michel Cadot
Messages: 68625
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Nothing is urgent in forum, we treat topics when we want.
Read the link Ana provided.

Goto Oracle documentation, and use Ctk-F "Security", you will find security guides.
Also have a look at AUDIT statement.

Regards
Michel
Previous Topic: How to hide passwords?
Next Topic: Oracle Profile
Goto Forum:
  


Current Time: Thu Mar 28 13:21:48 CDT 2024