Allow user to drop only tables / views created by that user in MySQL Is it possible to allow a user to only drop tables and views that he/she created in MySQL? How is this achieved?
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.