Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Question about privileges
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 addressReceived on Mon Mar 04 2002 - 15:55:19 CST
![]() |
![]() |