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.com@lists.launchpad.net] On Behalf Of Lukas Lehner
Sent: Monday, October 24, 2016 3:18 PM
To: Maria Discuss <maria-discuss@lists.launchpad.net>
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