Non-DBA users must use a fully-qualified name to drop an index [CR 548184]

For DROP INDEX, non-DBA users must provide a fully-qualified index name to drop an index on a base table owned by the DBA. DBA or users with the appropriate privileges can drop an index on tables that are owned by non-DBA users without using a fully-qualified name.