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 is a synonym.
all the v$ are really v_$. go to dba_views... see for yourself.
so grant on v_$. everyone gets nabbed by that one atleast once.
From: Foelz.Frank [EMAIL PROTECTED]
Date: 2003/07/15 Tue AM 09:59:31 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
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
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
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
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
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
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: