Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: referencing v$database from within a procedure
Yup, the usual: it doesn't work in the procedure because you've been granted
access to the V$ view via a role (probably the DBA role), and privileges
granted via a role aren't respected by PL/SQL. The grant has to be a direct
one (grant select on v$database to Bob). Then it will work.
Regards
HJR
"Bob Sleik" <bsleik_at_cbe.ab.ca> wrote in message
news:ddfcb22f.0207161546.28288aea_at_posting.google.com...
> I get an error "table or view does not exist" when I attempt to
> reference v$database from within a procedure. I can reference it with
> a select statement in SQLPlus. Any advise?
>
> Thanks,
> Bob
Received on Tue Jul 16 2002 - 18:49:45 CDT