| Goal | Privileges User Needs |
|---|---|
| Create hash or join index | CREATE TABLE privilege on the database in which the hash index or join index is created. |
| Drop hash index | DROP TABLE or INDEX privilege on the indexed base table or its containing database. |
| Drop join index | DROP TABLE or INDEX privilege on each of the covered tables or their containing databases. |