Re: Give user index grants Oracle 8/9i

On 2006-11-18, Sean <seanm555_at_comcast.net> wrote:
> Hello all,
>
> I'm new to Oracle, so I have a question that might be easy...
>
> I have created a primary key and a couple of indexes on a table. I can
> see that the schema owner has these constraints listed in the
> user_indexes table. I have created a new user, and given him select,
> insert, update, delete priviledges on the table. This new user can't
> see the constraints on the table, as I can see by checking the
> user_indexes table.
>
> How do I give the user permissions to the indexes on the table, so that
> he has the correct entries in the user_indexes table? Thanks,

Sean,

by default, all USER_* views only show entries for which the user quering the USER_* view is also the owner.

In your case, USER_INDEXES will only show the indexes that the "new" user actually owns.

Try using ALL_INDEXES instead.

hth, Rene

-- 
  Rene Nyffenegger
  http://www.adp-gmbh.ch