Give user index grants Oracle 8/9i

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 Received on Fri Nov 17 2006 - 18:33:33 CST