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: dba_xxx view in stored procedures

Re: dba_xxx view in stored procedures

From: Vijay Vardhineni <vardhineni_at_worldnet.att.net>
Date: 1997/01/07
Message-ID: <01bbfc5f$4f215da0$2e6993cf@default>#1/1 







Try connecting as SYS and grant the (direct) privileges on the DBA_xxxx
tables to you.  Privileges obtained through a role can not used for
creating procedures.



-- 
Vijaya Kumar Vardhineni
Oracle DBA, EDS
Plano, TX

JACK PEREYRA <JACK_PEREYRA_at_kne.com> wrote in article
<32D15B05.F9D_at_kne.com>...


> How do I use dba_xxx views in stored procedures to avoid getting

> PLS-00904: insufficient privilege to access object ?

> 

> Thanks

> 



Received on Tue Jan 07 1997 - 00:00:00 CST












Original text of this message













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