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,
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
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
]
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
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
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
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
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
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:
12 matches
Mail list logo