OraFAQ Forum: Security » Urgent: Workstation identify

Home » RDBMS Server » Security » Urgent: Workstation identify

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Urgent: Workstation identify [message #143744]

Fri, 21 October 2005 15:21

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

Mahesh Rajendran
Messages: 10708
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

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

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

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

woww answer after 2 years Wink

Wink

Report message to a moderator

Re: Urgent: Workstation identify [message #261052 is a reply to message #261026]

Tue, 21 August 2007 10:58

Michel Cadot
Messages: 68776
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

It's never too late.
He's just awake from a long coma. Laughing

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

DreamzZ
Messages: 1666
Registered: May 2007
Location: Dreamzland

Senior Member

Laughing

Laughing

/forum/fa/2923/0/

Attachment: d.gif
(Size: 36.47KB, Downloaded 2365 times)

Report message to a moderator

Re: Urgent: Workstation identify [message #262341 is a reply to message #143744]

Sun, 26 August 2007 05:20

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Aug 03 13:07:30 CDT 2026