RE: Can't see index from package

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Sat, 16 Sep 2006 07:42:05 -0600
Message-Id: <6.2.3.4.2.20060916074130.02ea6aa0@pop.centrexcc.com>

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

Received on Sat Sep 16 2006 - 08:42:05 CDT