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

Report message to a moderator

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: 10694
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?

Report message to a moderator

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?

Report message to a moderator

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;

Report message to a moderator

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

Report message to a moderator

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: 67769
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

Report message to a moderator

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 /forum/fa/2923/0/
  • Attachment: d.gif
    (Size: 36.47KB, Downloaded 493 times)

Report message to a moderator

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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat Mar 06 23:54:18 CST 2021
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.