Re: How to Restrict creation of UDF(User defined functions) in mysql 5.7

[Suman kumar]

Hi,

Thanks for the reply.
I want to restrict insert privilieges for a single user ,lets say "x".
Initially i have given

Grant all on *.* to x;
Revoke insert on mysql.func from x;


But error has been thrown saying " No such grant is specified".
Then i tried in the below sequence.

Grant all on *.* to x;
Grant insert on mysql.func to x;
Revoke insert on mysql.func from x;

But still i am able to insert the rows in mysql.func.


Please let me know how can i restrict only insert privileges to x on mysql.func and allow rest all prvileges in database.

Thanks
Suman