Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Question about privileges

Question about privileges

From: Syltrem <syltrem_at_videotron.spammenot.ca>
Date: Mon, 4 Mar 2002 16:55:19 -0500
Message-ID: <J2Sg8.1967$a04.11311@tor-nn1.netcom.ca>


I`m connected as someuser and I can do a select from v$mystat

Now I create a stored procedure (while logged on as someuser) which does the same thing,
and I get this error:
PLS-00201: identifier 'SYS.V_$MYSTAT' must be declared

Isn`t V$MYSTAT supposed to be readable by any user? Or do I have to manually grant select right from user SYS to table V$_MYSTAT? This is not quite clear to me.

Thanks!

--

Syltrem
http://pages.infinit.net/syltrem (OpenVMS related web site - en français)
To reply to myself directly, remove .spammenot from my address
Received on Mon Mar 04 2002 - 15:55:19 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US