24 Oct
2016
24 Oct
'16
3:53 p.m.
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