Question about indexes (indices)
From: Jacqueline Owens <owens_at_oasys.dt.navy.mil>
Date: 14 Jul 93 19:11:05 GMT
Message-ID: <39336_at_oasys.dt.navy.mil>
Date: 14 Jul 93 19:11:05 GMT
Message-ID: <39336_at_oasys.dt.navy.mil>
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.
Questions that make me say hmmm:
Is this an error in the data dictionary table?
Did they mean to say: INDEX_PRIV - Permission to create an index on the object only?
Any help would be appreciate.
Jackie O. Received on Wed Jul 14 1993 - 21:11:05 CEST