Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

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

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

From: <Jay.Miller_at_tdameritrade.com>
Date: Wed, 29 Aug 2007 14:11:21 -0400
Message-ID: <304CF4722010DD4FA19829D09DDB956BAC3029@prdhswsemlmb01.prod-am.ameritrade.com>


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 Wed Aug 29 2007 - 13:11:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US