v$session question

2003-07-15 Thread Foelz.Frank
Hi all, anyone able to tell me, how to grant v$session select privileges to a user ? grant select on v$session to xyuser* ORA-02030: can only select from fixed tables/views Cause: The keyword FILE is required in this context. Action: Check syntax, insert keyword FILE as required,

RE: v$session question

2003-07-15 Thread Jamadagni, Rajendra
Title: RE: v$session question grant select on sys.v_$session to xyuser / Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts

v$session question

2003-07-15 Thread Foelz.Frank
sorry, cut/copy/paste mismatch. I took the wrong error description. again.. anyone able to tell me, how to grant v$session select privileges to a user ? --- grant select on v$session to xyuser* ORA-02030: can

Re: v$session question

2003-07-15 Thread rgaffuri
] Subject: v$session question Hi all, anyone able to tell me, how to grant v$session select privileges to a user ? grant select on v$session to xyuser* ORA-02030: can only select from fixed tables/views Cause: The keyword FILE is required in this context. Action: Check

RE: v$session question

2003-07-15 Thread Nigel Bishop
GRANT SELECT ON V_$SESSION TO user; Regards Nigel Bishop Snr. Oracle DBA ioko Tel DDI: +44 (0) 1904 435 458 Mobile: +44 (0) 7881 624 386 Fax: +44 (0) 1904 435 450 Email:[EMAIL PROTECTED] www.ioko.com -Original Message- Sent: 15 July 2003 15:00 To: Multiple

AW: v$session question

2003-07-15 Thread Foelz.Frank
that helped, tnx a lot ! Frank -Ursprüngliche Nachricht- Von: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Gesendet am: Dienstag, 15. Juli 2003 16:15 An: Multiple recipients of list ORACLE-L Betreff: Re: v$session question v$session is a synonym. all the v$ are really v_$. go

Re: v$session question

2002-01-28 Thread Joe LaCascio
Thanks for the info about module. I've got a script myself that show's info like GUI/character users, connect times etc... The piece I was now missing was the module field. Thanks for the info. Joe On Fri, 25 Jan 2002, Catherine LeBlanc wrote: Yes, that will do it, but module does not have

RE: v$session question

2002-01-28 Thread Reardon, Bruce (CALBBAY)
Hi, There is a bug (1237128, http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=BUGp_id=1237128) that might be related to this. The title of the bug is V$SESSION.PROGRAM HAS NO VALUE USING WINNT ORACLE8/8I CLIENT CONNECTION In our case, we see this when 816 NT

v$session question

2002-01-25 Thread Joe LaCascio
In the past, I was running Oracle 8.1.5 and the clients were running Oracle Forms 4.5. When I queried v$session and looked at the program field I could see what clients where running f45run32.exe. Now we are on Oracle 8.1.6 and the clients are running Forms60. When I now query v$session the

Re: v$session question

2002-01-25 Thread nlzanen1
Hi, Try module in v$session (just a guess) Jack Joe LaCascio [EMAIL PROTECTED]@fatcity.com on 25-01-2002 15:35:24 Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc:(bcc: Jack van

RE: v$session question

2002-01-25 Thread Deshpande, Kirti
What platform? On HP-UX 11.0 and Oracle 8.1.6.2.0 and w/ Clients on Win/NT 4 Workstations, here is what I get: (last few lines) SQL select username, program from v$session; USERNAMEPROGRAM --- --- X468Y02 C:\orant\bin\ifrun60.exe X0C0AJF

Re: v$session question

2002-01-25 Thread Catherine LeBlanc
Yes, that will do it, but module does not have ifrun60, it has the actual Oracle form name that the user is running. Joe, I have a script to show all active connections and all that stuff if you want it. Catherine LeBlanc DBA, Bates College, Lewiston, ME At 07:36 AM 1/25/02 -0800, you wrote: