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

  • From: <Jay.Miller@xxxxxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Wed, 29 Aug 2007 14:11:21 -0400

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

Jay Miller 


Other related posts: