Re: dba_xxx view in stored procedures

From: Lun Wing San (Oracle) <wslun_at_qrcsun.qrc.org>
Date: 1997/01/07
Message-ID: <32D26FA1.BBF@qrcsun.qrc.org>#1/1

JACK PEREYRA wrote:
>
> How do I use dba_xxx views in stored procedures to avoid getting
> PLS-00904: insufficient privilege to access object ?
>
> Thanks

Grant SELECT on dba_xxx DIRECTLY to the procedure owner but not through role if you have any.

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841

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