Dropping an indexA Lucene index can be dropped by the table owner.luceneSupport optional tooldropping an index
If SQL authorization is enabled, the database owner is the only account which
can drop an index on another user's table. The following procedure makes this
possible: