MySQL Forums
Forum List  »  Security

Advanced Search
New Topic

Re: How to Restrict creation of UDF(User defined functions) in mysql 5.7
Posted by: Georgi Kodinov
Date: February 20, 2017 07:59AM

https://dev.mysql.com/doc/refman/5.7/en/create-function-udf.html says:

To create a function, you must have the INSERT privilege for the mysql database. This is necessary because CREATE FUNCTION adds a row to the mysql.func system table that records the function's name, type, and shared library name.

So maybe try removing that for all of your users ?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
How to Restrict creation of UDF(User defined functions) in mysql 5.7
1091
Suman kumar
February 17, 2017 06:36AM
Re: How to Restrict creation of UDF(User defined functions) in mysql 5.7
1754
Georgi Kodinov
February 20, 2017 07:59AM
Re: How to Restrict creation of UDF(User defined functions) in mysql 5.7
992
Suman kumar
February 20, 2017 11:48PM
Re: How to Restrict creation of UDF(User defined functions) in mysql 5.7
839
Georgi Kodinov
February 21, 2017 06:00AM


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.