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 > > >