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

Taking care to catch the sql injection possibilities you'll give these knowledgeable users!

On 30/08/2007, LS Cheng <exriscer_at_gmail.com> wrote:
> 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
> >
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l