CREATE INDEX ACCESS

Database

CREATE INDEX ACCESS

I have access to create / drop table in a particular database but dont know why I am not able to create Index on a already existing table..

Does it requires any extra sort of permissions to create indexes???

1 REPLY

Re: CREATE INDEX ACCESS

The DROP TABLE access right should be sufficient to create an index.  If a request fails because of an access right violation, the error message should tell you exactly which access right was lacking.