Re: v$databse

Guido vd Zweerde wrote:
>
> Hi,
>
> consider the next problem:
>
> connected as system
> select name from v$database;
> --> returns SID-name
>
> when in the next procedure :
> create or replace procedure t
> is
> x char(8);
> begin
> select name
> into x
> from v$database;
> end;
> /
>
> I get the next error:
> LINE/COL ERROR
> -----------------------------------------------------------------
> 5/3 PL/SQL: SQL Statement ignored
> 7/8 PLS-00201: identifier 'SYS.V_$DATABASE' must be declared
>
> What is the problem? If I create the procedure as 'SYS' it works, but
> that is not what I want.
>
> Thanx,
> Guido vd Zweerde
> University of Twente
> The Netherlands
> G.R.vandeZweerde_at_civ.utwente.nl

Guido:

Whoever is creating this procedure must have select access to v_$database granted DIRECTLY to them, NOT via a role.

grant select on v_$database to procedure_owner;

Then they should be able to compile the procedure.

John Hough Received on Wed Mar 26 1997 - 00:00:00 CST