Home » RDBMS Server » Security » Urgent: Workstation identify
icon5.gif  Urgent: Workstation identify [message #143744] Fri, 21 October 2005 15:21 Go to next message
franjomarkovic
Messages: 2
Registered: October 2005
Junior Member
Hi,

can I identify the "workstation" of a user who has made a particular operation, e.g. a drop table?
In fact the same oracle user is assigned to more people, so I need to know haw to retrive the workstation where the operation has been done.

thanks
Re: Urgent: Workstation identify [message #143749 is a reply to message #143744] Fri, 21 October 2005 18:10 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10630
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>>can I identify the "workstation" of a user who has made a particular operation, e.g. a drop table
Yes you can.
But , you need to have the auditing enabled before.
Do you have auditing enabled?
Re: Urgent: Workstation identify [message #143764 is a reply to message #143749] Sat, 22 October 2005 02:05 Go to previous messageGo to next message
franjomarkovic
Messages: 2
Registered: October 2005
Junior Member
Yes, I've.
What shall I do?
Re: Urgent: Workstation identify [message #261022 is a reply to message #143764] Tue, 21 August 2007 09:36 Go to previous messageGo to next message
kafaween
Messages: 7
Registered: August 2007
Location: Jordan
Junior Member
hi

just do:

SQL>audit create session by scott;

SQL>select username,userhost from dba_audit_session;




Re: Urgent: Workstation identify [message #261026 is a reply to message #261022] Tue, 21 August 2007 09:38 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
woww answer after 2 years Wink
Re: Urgent: Workstation identify [message #261052 is a reply to message #261026] Tue, 21 August 2007 10:58 Go to previous messageGo to next message
Michel Cadot
Messages: 59791
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It's never too late.
He's just awake from a long coma. Laughing

Regards
Michel
Re: Urgent: Workstation identify [message #261054 is a reply to message #261052] Tue, 21 August 2007 11:22 Go to previous messageGo to next message
DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland
Senior Member
Laughing Laughing ./fa/2923/0/
  • Attachment: d.gif
    (Size: 36.47KB, Downloaded 225 times)
Re: Urgent: Workstation identify [message #262341 is a reply to message #143744] Sun, 26 August 2007 05:20 Go to previous message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Quote:
long coma


Laughing
Previous Topic: Disabling OS Authentication - Ramifications
Next Topic: Row-level auditing
Goto Forum:
  


Current Time: Wed Nov 26 11:40:13 CST 2014

Total time taken to generate the page: 0.10802 seconds