Re: Give user index grants Oracle 8/9i

Sean 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

The USER_n views (USER_TABLES, USER_INDEXES, USER_VIEWS, etc.) are specific to each user - if a user creates a table, index, view, etc. it will show in that user's USER_n set of views. The ALL_n views show all tables, indexes, views, etc. that the user may access using a syntax similar to: OWNER.TABLENAME. The DBA_n views show those objects that database administrators may access.

Permission may be granted to a table, but not an index.

Charles Hooper
PC Support Specialist
K&M Machine-Fabricating, Inc. Received on Fri Nov 17 2006 - 19:04:33 CST