Re: Question about indexes (indices)

In article <39336_at_oasys.dt.navy.mil>, owens_at_oasys.dt.navy.mil (Jacqueline Owens) wrote:
>
> Scenario: There exists an index on some table. The owner has granted
> me all priv's on the table (my primary interest here is
> the index priv).
>
> Question: Why can't I drop the index under my username when in fact
> the data dictionary table (namely user_tab_grants) says
> that I have index_priv (Permission to create/drop an index
> on the object)? Btw, I am aware that the DROP INDEX command
> states that I must be the owner of the index or have DBA
> priv's.

So do you have DBA privs? Is the index is owned by you? If not, are you using the owner.index format to identify the index? Any DDL statement that you apply to objects that are not your own will need the owner.object format.

Hope this helps.

-Devan

                             
               Devan F. Dewey | Senior Systems Analyst
          CenterLine Software | dewey_at_centerline.com
            10 Fawcett Street | "Leme esplain - no dere is
          Cambridge, MA 02138 | too much. Leme sum up."
                                       -Inigo Montoya