Home » RDBMS Server » Server Administration » how to find the user name who executes sql statement
how to find the user name who executes sql statement [message #56808] Sat, 26 April 2003 23:12 Go to next message
Anu
Messages: 82
Registered: May 2000
Member
Hi,
From v$sql I am able to find all the sql statements. How can I find the username who executed this statements.

Thanks in advance

Anu

Report message to a moderator

Re: how to find the user name who executes sql statement [message #56809 is a reply to message #56808] Sun, 27 April 2003 13:01 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
Also see if V$sqltext and V$session / combination will help u in resolving this issue..

sai

Report message to a moderator

Previous Topic: Can anyone help me answer following question, please?
Next Topic: get oracle jobs,training,certification free from this group named ocpfree in yahoo
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 09:27:47 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.