Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> ora 1039 when running explain plan on a view without SELECT priv on underlying table
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-lReceived on Wed Aug 29 2007 - 13:11:21 CDT
![]() |
![]() |