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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: ora 1039 when running explain plan on a view without SELECT priv on underlying table

From: LS Cheng <exriscer_at_gmail.com>
Date: Thu, 30 Aug 2007 07:16:00 +0200
Message-ID: <6e9345580708292216g1316f4acw2dbe04ab00436642@mail.gmail.com>

You can try with a stored procedure.

Thanks

--
LSC



On 8/29/07, Jay.Miller_at_tdameritrade.com <Jay.Miller_at_tdameritrade.com> wrote:


>

>  Is there any way to allow someone to run Explain Plan for a query that

> references a view when they do not have select privileges on the

> underlying table?  We recently put views in place to hide some sensitive

> data but users can no longer run explain plans for their queries since they

> only have select on the view.

>

> Anyone know of a workaround?

>

>

> Solaris 2.8

> Oracle 9.2.0.7

>

> Thanks,

>

> Jay Miller

>

>

>


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

Received on Thu Aug 30 2007 - 00:16:00 CDT