I have a patch to be "DROP DATABASE need Super_priv" https://gist.github.com/yoku0825/ec783f4f2b6350a860c4736ad4739d16
yoku0825, 2016-10-25 16:43 GMT+09:00 Lukas Lehner <[email protected]>: > Thanks Rhys. > > Is there an other way? With your solution the customer can't use standard > SQL (they are forced to use our procedure), which means much more support > requests. > > best regards > Lukas > > On Mon, Oct 24, 2016 at 3:53 PM, <[email protected]> wrote: >> >> 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 > _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : [email protected] Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
