| To... | the user must have the... |
|---|---|
| create a hash or join index | CREATE TABLE privilege on the database in which the hash index or join index is created. |
| drop a hash index | DROP TABLE or INDEX privilege on the indexed base table or its containing database. |
| drop a join index | DROP TABLE or INDEX privilege on each of the covered tables or their containing databases. |