Function Permissions : Function « Procedure Function « MySQL Tutorial

There are two sets of permissions for stored functions,

1. permissions to create and manage stored functions
2. permissions to use functions.

To create a function in a database, the user must have the CREATE ROUTINE privilege.

To use a function, the caller must have the EXECUTE privilege for the particular database.

To change an existing function, the user must have the ALTER ROUTINE privilege.

Permissions can be granted globally in the mysql.user table.

Permissions can also be granted at the database level in the mysql.db table.

Permissions can be granted for a specific routine in the mysql.procs_priv table.