RE: v$session question

From: Jamadagni, Rajendra <Rajendra.Jamadagni_at_espn.com>
Date: Tue, 15 Jul 2003 09:10:15 -0400
Message-Id: <25929.337792@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------=_NextPartTM-000-5e3f8d00-ff22-4e5c-8e28-932a1bafb584 Content-Type: multipart/alternative;

boundary="----_=_NextPart_001_01C34AD2.6E5BBF80"

------_=_NextPart_001_01C34AD2.6E5BBF80
Content-Type: text/plain;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

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, having an opinion is an art !

-----Original Message-----
From: Foelz.Frank [mailto:Foelz.Frank_at_Scheidt-Bachmann.de] Sent: Tuesday, July 15, 2003 10:00 AM
To: Multiple recipients of list ORACLE-L Subject: v$session question

Hi all,
=20

anyone able to tell me, how to grant v$session select privileges to a = user ?
=20
=20

grant select on v$session to xyuser*
ORA-02030: can only select from fixed tables/views
=20

Cause:=20
The keyword FILE is required in this context.=20

=20

Action:=20
Check syntax, insert keyword FILE as required, and try again.=20

=20

ORA-02030 can only select from fixed tables/views=20

> Frank Foelz =D3=BF=D2 <

Scheidt & Bachmann GmbH
Gestaltung Parkhaussysteme
Breite Strasse 132
41238 Moenchengladbach

Phone : ++49 2166 / 266 - 837
Fax: ++49 2166 / 266 - 615

e-mail :  mailto:Foelz.Frank_at_Scheidt-Bachmann.de
<mailto:Foelz.Frank_at_Scheidt-Bachmann.de>=20
URL    :  http://www.scheidt-bachmann.de =

<http://www.scheidt-bachmann.de/>=20

________________________________________________________________________=

=20

------------------------------------------------------------------------=

---=20
Confidentiality Note=20
=20
Diese E-Mail mit allen angeh=E4ngten Dateien ist ausschlie=DFlich = f=FCr die=20
Person/Personen bestimmt, an die diese adressiert ist und = k=F6nnte=20
vertrauliche und/oder rechtlich gesch=FCtzte Informationen enthalten. = Sollten=20
Sie nicht der f=FCr diese E-Mail bestimmte Adressat oder nicht zum = Empfang=20
berechtigt sein, ist Ihnen jeder Gebrauch, sowie jede = Ver=F6ffentlichung,=20
Vervielf=E4ltigung oder Weitergabe wie auch das Ergreifen = oder=20
Unterlassen von Ma=DFnahmen im Vertrauen auf erlangte = Information=20
untersagt. Sollten Sie diese E-Mail irrt=FCmlich erhalten = haben,=20
benachrichtigen Sie bitte den Absender und l=F6schen diese = E-Mail von=20
jedem Computer. E-Mail-Mitteilungen sind nicht notwendigerweise = sicher.=20
Scheidt & Bachmann =FCbernimmt keine Verantwortung f=FCr = Ver=E4nderungen dieser=20
Mitteilung, die nach dem Senden vorgenommen wurden. =20 Herzlichen Dank f=FCr Ihre Unterst=FCtzung!=20 =20
This email and any files transmitted is intended only for the = person or=20
entity to which it is addressed and may contain confidential = and/or=20
privileged material. If you are not the authorised recipient, any = use,=20
disclosure, copying, distribution or any action taken or omitted = to be=20
taken in reliance on it, is prohibited. If you received this in = error,=20
please contact the sender and delete the material from any = computer.=20
E-mail messages are not necessarily secure. Scheidt & Bachmann does = not=20
accept responsibility for any changes made to this message after = it=20
was sent.=20
Thank you for your cooperation!=20

------------------------------------------------------------------------=

---=20

--=20
Please see the official ORACLE-L FAQ: http://www.orafaq.net --=20
Author: Foelz.Frank
INET: Foelz.Frank_at_Scheidt-Bachmann.de

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: ListGuru_at_fatcity.com (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).

------_=_NextPart_001_01C34AD2.6E5BBF80
Content-Type: text/html;

charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =

charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2654.19">

<TITLE>RE: v$session question</TITLE>
</HEAD>
<BODY>

<P><FONT SIZE=3D2>grant select on sys.v_$session to xyuser</FONT>

/

Raj
 <FONT =

SIZE=3D2>---------------------------------------------------------------=
-----------------</FONT>

Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly = personal.
 QOTD: Any clod can have facts, having an opinion is = an art !

-----Original Message----- From: Foelz.Frank [<A = HREF=3D"mailto:Foelz.Frank_at_Scheidt-Bachmann.de">mailto:Foelz.Frank_at_Schei= dt-Bachmann.de</A>]

<BR><FONT SIZE=3D2>Sent: Tuesday, July 15, 2003 10:00 AM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: v$session question</FONT>
</P>
<BR>

<P><FONT SIZE=3D2>Hi all,</FONT>

anyone able to tell me, how to grant v$session = select privileges to a user ?

<BR><FONT SIZE=3D2>&nbsp;</FONT>
<BR><FONT SIZE=3D2>&nbsp;</FONT>
<BR><FONT SIZE=3D2>grant select on v$session to xyuser*</FONT>
<BR><FONT SIZE=3D2>ORA-02030: can only select from fixed =

tables/views

<P><FONT SIZE=3D2>Cause: </FONT>
<BR><FONT SIZE=3D2>The keyword FILE is required in this context. =
</FONT>
</P>

Action: 
 Check syntax, insert keyword FILE as required, and = try again.

<P><FONT SIZE=3D2>&nbsp;</FONT>
<BR><FONT SIZE=3D2>ORA-02030 can only select from fixed tables/views =
</FONT>
</P>

<P><FONT SIZE=3D2>&gt; Frank Foelz&nbsp; =D3=BF=D2 &lt;</FONT>
<BR><FONT SIZE=3D2>_________________________________</FONT>
<BR><FONT SIZE=3D2>Scheidt &amp; Bachmann GmbH</FONT>
<BR><FONT SIZE=3D2>Gestaltung Parkhaussysteme</FONT>
<BR><FONT SIZE=3D2>Breite Strasse 132</FONT>

41238 Moenchengladbach

Phone  :  ++49 2166 / 266 - 837 Fax:      ++49 2166 / 266 - = 615
 e-mail :  <A =
HREF=3D"mailto:Foelz.Frank_at_Scheidt-Bachmann.de">mailto:Foelz.Frank_at_Schei= dt-Bachmann.de</A>
 <<A =
HREF=3D"mailto:Foelz.Frank_at_Scheidt-Bachmann.de">mailto:Foelz.Frank_at_Schei= dt-Bachmann.de</A>> 
 URL    :  <A = HREF=3D"http://www.scheidt-bachmann.de" = TARGET=3D"_blank">http://www.scheidt-bachmann.de</A> <<A = HREF=3D"http://www.scheidt-bachmann.de/" = TARGET=3D"_blank">http://www.scheidt-bachmann.de/</A>> <FONT =

SIZE=3D2>_______________________________________________________________=

_________

<FONT =

SIZE=3D2>---------------------------------------------------------------=

------------

<BR><FONT SIZE=3D2>Confidentiality Note </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>Diese&nbsp; E-Mail&nbsp; mit&nbsp; allen =

angeh=E4ngten Dateien  ist  ausschlie=DFlich  f=FCr die = 
 Person/Personen  bestimmt,   an  = die   diese  adressiert   ist  und  = k=F6nnte 
 vertrauliche und/oder rechtlich gesch=FCtzte = Informationen enthalten. Sollten Sie  nicht der  f=FCr diese E-Mail  = bestimmte Adressat oder nicht zum Empfang berechtigt  sein,  ist Ihnen  jeder = Gebrauch,  sowie jede Ver=F6ffentlichung, Vervielf=E4ltigung   oder  = Weitergabe    wie   auch    = das   Ergreifen   oder Unterlassen   von   = Ma=DFnahmen   im  Vertrauen   auf   = erlangte  Information 
 untersagt.   Sollten   = Sie    diese  E-Mail  = irrt=FCmlich    erhalten  haben, benachrichtigen  Sie  bitte   = den  Absender und  l=F6schen  diese E-Mail  von = 
 jedem  Computer.  = E-Mail-Mitteilungen  sind  nicht notwendigerweise sicher. = 
 Scheidt &  Bachmann =FCbernimmt  keine = Verantwortung f=FCr Ver=E4nderungen dieser Mitteilung, die nach dem Senden vorgenommen = wurden.

<BR><FONT SIZE=3D2>Herzlichen Dank f=FCr Ihre Unterst=FCtzung! </FONT>
<BR><FONT SIZE=3D2>&nbsp; </FONT>
<BR><FONT SIZE=3D2>This email and any&nbsp; files transmitted&nbsp; 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 =

</FONT>
<BR><FONT SIZE=3D2>was sent. </FONT>
<BR><FONT SIZE=3D2>Thank you for your cooperation! </FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=

------------

-- 
 Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.net" =
TARGET=3D"_blank">http://www.orafaq.net</A>

<BR><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Foelz.Frank</FONT>
<BR><FONT SIZE=3D2>&nbsp; INET: Foelz.Frank_at_Scheidt-Bachmann.de</FONT>
</P>

Fat City Network Services    -- = 858-538-5051 <A HREF=3D"http://www.fatcity.com" = TARGET=3D"_blank">http://www.fatcity.com</A> San Diego, =
California        -- Mailing list = and web hosting services
 <FONT =

SIZE=3D2>---------------------------------------------------------------=

------
 To REMOVE yourself from this mailing list, send an = E-Mail message
 to: ListGuru_at_fatcity.com (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).

</BODY>
</HTML>
------_=_NextPart_001_01C34AD2.6E5BBF80--

------=_NextPartTM-000-5e3f8d00-ff22-4e5c-8e28-932a1bafb584 Content-Type: text/plain;

name="ESPN_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;

filename="ESPN_Disclaimer.txt"

*********************************************************************This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*********************************************************************1

Received on Tue Jul 15 2003 - 08:10:15 CDT