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 recipients of list ORACLE-L
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: Nigel Bishop
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).
