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

Regards

Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com


--
http://www.freelists.org/webpage/oracle-l


Other related posts: