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]> > 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 syntax, insert keyword FILE as required, and try again. > > > ORA-02030 can only select from fixed tables/views > > > Frank Foelz Ó¿Ò < > _________________________________ > Scheidt & Bachmann GmbH > Gestaltung Parkhaussysteme > Breite Strasse 132 > 41238 Moenchengladbach > > Phone : ++49 2166 / 266 - 837 > Fax: ++49 2166 / 266 - 615 > e-mail : mailto:[EMAIL PROTECTED] > <mailto:[EMAIL PROTECTED]> > URL : http://www.scheidt-bachmann.de <http://www.scheidt-bachmann.de/> > ________________________________________________________________________ > > > > --------------------------------------------------------------------------- > Confidentiality Note > > Diese E-Mail mit allen angehängten Dateien ist ausschließlich für die > Person/Personen bestimmt, an die diese adressiert ist und könnte > vertrauliche und/oder rechtlich geschützte Informationen enthalten. Sollten > Sie nicht der für diese E-Mail bestimmte Adressat oder nicht zum Empfang > berechtigt sein, ist Ihnen jeder Gebrauch, sowie jede Veröffentlichung, > Vervielfältigung oder Weitergabe wie auch das Ergreifen oder > Unterlassen von Maßnahmen im Vertrauen auf erlangte Information > untersagt. Sollten Sie diese E-Mail irrtümlich erhalten haben, > benachrichtigen Sie bitte den Absender und löschen diese E-Mail von > jedem Computer. E-Mail-Mitteilungen sind nicht notwendigerweise sicher. > Scheidt & Bachmann übernimmt keine Verantwortung für Veränderungen dieser > Mitteilung, die nach dem Senden vorgenommen wurden. > Herzlichen Dank für Ihre Unterstützung! > > This email and any files transmitted is intended only for the person or > entity to which it is addressed and may contain confidential and/or > privileged material. If you are not the authorised recipient, any use, > disclosure, copying, distribution or any action taken or omitted to be > taken in reliance on it, is prohibited. If you received this in error, > please contact the sender and delete the material from any computer. > E-mail messages are not necessarily secure. Scheidt & Bachmann does not > accept responsibility for any changes made to this message after it > was sent. > Thank you for your cooperation! > --------------------------------------------------------------------------- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Foelz.Frank > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > --------------------------------------------------------------------- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services --------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).