Re: ora 1039 when running explain plan on a view without SELECT priv on underlying table
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: "Jared Still" <jkstill@xxxxxxxxx>
- Date: Thu, 30 Aug 2007 09:08:35 +0200
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:
