Re: ora 1039 when running explain plan on a view without SELECT priv on underlying table
- From: "LS Cheng" <exriscer@xxxxxxxxx>
- To: Jay.Miller@xxxxxxxxxxxxxxxx
- Date: Thu, 30 Aug 2007 07:16:00 +0200
Hi
You can try with a stored procedure.
Thanks
--
LSC
On 8/29/07, Jay.Miller@xxxxxxxxxxxxxxxx <Jay.Miller@xxxxxxxxxxxxxxxx> 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
>
>
>
Other related posts:
