RE: Can we find SQL user

2002-06-09 Thread sam d
Message- From: sam d [mailto:[EMAIL PROTECTED]] Sent: Friday, June 07, 2002 1:18 AM To: Multiple recipients of list ORACLE-L Subject: Can we find SQL user Hi List, Suppose I have m1,m2,m3 machines, all the users sitting on these machines are using oracle 'user1' to connect

RE: Can we find SQL user

2002-06-07 Thread sam d
We can definitely find the user , but considering my scenario 'all the people are logged in with the same oracle user' , I want to know:From what machine the SQL statement was fired. thx Sam name--- Reardon, Bruce (CALBBAY) [EMAIL PROTECTED] wrote: Have a look at v$session In particular the

RE: RE: Can we find SQL user

2002-06-07 Thread Stephane Faroult
Sam, It looks like you have read Bruce's answer a little too fast. You might also like to RTFM the SQL Reference book, section 'functions', entry SYS_CONTEXT - although if you also want the SQL text, as Mladen said you must any way join V$SESSION and V$SQLAREA - or V$SQLTEXT if your

Re: Can we find SQL user

2002-06-07 Thread Jared Still
Bruce already mentioned using v$session. Have you tried it? If you try it, you will find it. Jared On Friday 07 June 2002 00:13, sam d wrote: We can definitely find the user , but considering my scenario 'all the people are logged in with the same oracle user' , I want to know:From what

RE: Can we find SQL user

2002-06-07 Thread Bernard, Gilbert
À: Multiple recipients of list ORACLE-L Objet: Re: Can we find SQL user Bruce already mentioned using v$session. Have you tried it? If you try it, you will find it. Jared On Friday 07 June 2002 00:13, sam d wrote: We can definitely find

Can we find SQL user

2002-06-06 Thread sam d
Hi List, Suppose I have m1,m2,m3 machines, all the users sitting on these machines are using oracle 'user1' to connect to the server. As all the people are logged in with the same user name ,Can we find which user(or machine) has issued which SQL statement. Thanks Sam

RE: Can we find SQL user

2002-06-06 Thread Reardon, Bruce (CALBBAY)
Have a look at v$session In particular the osuser, terminal and machine fields - these may help Also look at the listener log file - this may help Or do you have an application server sitting in the middle? HTH, Bruce Reardon -Original Message- Sent: Friday, 7 June 2002 15:18 Hi List,

Re: Can we find SQL user

2002-06-06 Thread Mladen Gogala
Yes you can, just join v$session and v$sqlarea. On 2002.06.07 01:18 sam d wrote: Hi List, Suppose I have m1,m2,m3 machines, all the users sitting on these machines are using oracle 'user1' to connect to the server. As all the people are logged in with the same user name ,Can we find