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 -> Re: referencing v$database from within a procedure

Re: referencing v$database from within a procedure

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Wed, 17 Jul 2002 09:49:45 +1000
Message-ID: <ah2bdi$onn$1@lust.ihug.co.nz>


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

Original text of this message

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