Home » RDBMS Server » Security » name of computer
name of computer [message #633306] Sun, 15 February 2015 05:55 Go to next message
lecondore
Messages: 1
Registered: February 2015
Location: sale
Junior Member
Hello a change has been made in a record oracle, it knows the user but we would like to identify the name of the computer, thanks Confused


[EDITED by LF: fixed topic title typo; was "compter"]

[Updated on: Mon, 16 February 2015 00:02] by Moderator

Report message to a moderator

Re: name of compter [message #633307 is a reply to message #633306] Sun, 15 February 2015 06:16 Go to previous messageGo to next message
BlackSwan
Messages: 26539
Registered: January 2009
Location: SoCal
Senior Member
Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and read http://www.orafaq.com/forum/t/174502/

It may not be possible to learn the name of the computer.

Was change done by 3-tier application?
Re: name of compter [message #633308 is a reply to message #633306] Sun, 15 February 2015 07:18 Go to previous messageGo to next message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

How do you know the name of the user?

Re: name of compter [message #633309 is a reply to message #633308] Sun, 15 February 2015 07:46 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3141
Registered: May 2013
Location: World Wide on the Web
Senior Member
@OP, and which user, application user or database user?
Re: name of compter [message #633333 is a reply to message #633309] Mon, 16 February 2015 02:45 Go to previous message
cookiemonster
Messages: 13630
Registered: September 2008
Location: Rainy Manchester
Senior Member
If this is a change that has happened and you have no code to record which machine was used then you have no way of finding out for sure.
You may be able to find out which machine a particular user is connected from, depending on the architecture of the application, but even if you can find that out you can't know if that was the machine used in the past.
Previous Topic: Bypassing ADMINISTER DATABASE TRIGGER
Next Topic: Audit overview was is being audited
Goto Forum:
  


Current Time: Thu Jun 20 12:07:18 CDT 2019