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???
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.