RE: Can't see index from package
- From: Wolfgang Breitling <breitliw@xxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Sat, 16 Sep 2006 07:42:05 -0600
You'll need to grant "references" on the table directly to the package owner.
At 12:33 PM 9/15/2006, Jonathan Knight wrote:
Mark, Your suggestion actually fixed our issue querying an "all_tab..." view. Now, we're facing "all_indexes".
We've granted select, update, delete, & alter on the table (which has the index) to the package owner. We've also granted ... INDEX ALTER ANY INDEXTYPE EXECUTE ANY INDEXTYPE
I know we're just shooting from the hip at the moment, but hoping to find the right one ...
Centrex Consulting Corporation