MySQL Forums
Forum List  »  Security

Re: How to Restrict creation of UDF(User defined functions) in mysql 5.7
Posted by: Suman kumar
Date: February 20, 2017 11:48PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to Restrict creation of UDF(User defined functions) in mysql 5.7
992
February 20, 2017 11:48PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.