Re: ora 1039 when running explain plan on a view without SELECT priv on underlying table

ah, I meant something like

As table owner

create or replace procedure xx (p_sql varchar2) as
begin

        excute immediate 'explain plan for ' || p_sql; end;
/

then grant execution priv to the unprivileged user, the caveage might be p_sql, must be clob or long....

thanks

--
LSC


On 8/30/07, Jared Still <jkstill_at_gmail.com> wrote:


>

> On 8/29/07, LS Cheng <exriscer_at_gmail.com> wrote:

> >

> > Hi

> >

> > You can try with a stored procedure.

> >

> >

>

> I tried recompiling dbms_xplan with definers rights earlier today,

> no wait, now it was yesterday.  :)

>

> Anyway, that didn't work.

>

> --

> Jared Still

> Certifiable Oracle DBA and Part Time Perl Evangelist

>


--
http://www.freelists.org/webpage/oracle-l