maria-discuss team mailing list archive

[<Rhys.Campbell@xxxxxxxxxxxx>]

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