OraFAQ Forum: Server Administration » how to find the user name who executes sql statement

Home » RDBMS Server » Server Administration » how to find the user name who executes sql statement

Sat, 26 April 2003 23:12

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

Sun, 27 April 2003 13:01

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

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:

]

Current Time: Mon Dec 30 16:20:41 CST 2024