Re: Question about privileges

From: damorgan <dan.morgan_at_ci.seattle.wa.us>
Date: Mon, 04 Mar 2002 22:00:50 GMT
Message-ID: <3C83EE9A.BEC4DC88@ci.seattle.wa.us>

Your privileges have been granted using a role. This will not work in a stored procedure. You need to have the privilege granted to your schema directly.

Daniel Morgan

Syltrem wrote:

> 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 - 16:00:50 CST