maria-discuss team mailing list archive

["yoku ts." <yoku0825@xxxxxxxxx>]

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 <weblehner@xxxxxxxxx>:
> 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
>