CREATE AGGREGATE FUNCTION

ranjithks

New Member
Joined
Sep 3, 2021
Messages
8
Reaction score
0
Credits
65
ERROR writing file in 'mysql.func' (errno: 1 - Operation not permitted)

I am getting the error while try to create a function as a application user. Please suggest what kind of privilege need to be added for the application user.

This is my MYSQL version:
mysql Ver 8.0.25 for Linux on x86_64 (MySQL Community Server - GPL)
 


Security
You must have the EXECUTE privilege on a function to call it. MariaDB automatically grants the EXECUTE and ALTER ROUTINE privileges to the account that called CREATE FUNCTION, even if the DEFINER clause was used.

Each function has an account associated as the definer. By default, the definer is the account that created the function. Use the DEFINER clause to specify a different account as the definer. You must have the SUPER privilege, or, from MariaDB 10.5.2, the SET USER privilege, to use the DEFINER clause. See Account Names for details on specifying accounts.
 
 

Members online


Latest posts

Top