← Back to team overview

maria-discuss team mailing list archive

Re: workaround for MDEV-9688

 

Use ProxySQL to rewrite DROP DATABASE to a call to a store proc.

Sent from my iPhone

> On Oct 25, 2016, at 3:43 AM, Lukas Lehner <weblehner@xxxxxxxxx> wrote:
> 
> 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, <Rhys.Campbell@xxxxxxxxxxxx> 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.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
>> 
> 
> _______________________________________________
> Mailing list: https://launchpad.net/~maria-discuss
> Post to     : maria-discuss@xxxxxxxxxxxxxxxxxxx
> Unsubscribe : https://launchpad.net/~maria-discuss
> More help   : https://help.launchpad.net/ListHelp

References