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@xxxxxxxxx> wrote:
>
> On 8/29/07, LS Cheng <exriscer@xxxxxxxxx> 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
>

Other related posts: