Revoke the DROP permission from the user in question. Create a stored procedure that can drop the tables using the SQL SECURITY DEFINER clause so it's executed in the context of a user with the DROP permission.
https://mariadb.com/kb/en/mariadb/create-procedure/ From: Maria-discuss [mailto:maria-discuss-bounces+rhys.campbell=swisscom....@lists.launchpad.net] On Behalf Of Lukas Lehner Sent: Monday, October 24, 2016 3:18 PM To: Maria Discuss <[email protected]> Subject: [Maria-discuss] workaround for MDEV-9688 Hi https://jira.mariadb.org/browse/MDEV-9688 is there a workaround for this issue? We need it for DBaaS Lukas
_______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
