Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> 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
Normally you never give anyone direct access to be able to login as the schema owner ( except perhaps in a development environment ). Through roles you can grant access as needed to views, procedures, and ( perhaps ) base tables in application schemas.
Oracle does have some special roles such as DBA that perhaps could provide access. There's a lot of different opinions with the oracle community as to whether the DBA role should be used. Certainly the usage of DBA in a production or qa environment needs to be restricted and authorized and monitored, perhaps the same applies to development and test environments depending on the organization, the policies, and the presence ( or not ) of sensitive data.
If you are having trouble seeing indexes and constraint information related to tables perhaps it is more because of the choice of tools you are using instead of available permissions? There are a number of widely used development tools including Toad, allroundautomations ( sp? ) SQL Developer, and oracle's sql developer. You may want to take a look at some of those tools. Received on Sat Nov 18 2006 - 08:05:54 CST