Allow user to drop only tables / views created by that user in MySQL
I'd create a dedicated MySQL instance per user (with docker for example) and let them do whatever they want. Your situation maybe different, of course, I'm just sharing an idea.