CTION statement. However,
you cannot change the parameters or body of a stored function using this
statement; to make such changes, you must drop and re-create the function
using DROP FUNCTION and CREATE FUNCTION.

You must have the ALTER ROUTINE privilege for the function. (That privilege is
granted automatically to the function creator.) If binary logging is enabled,
the ALTER FUNCTION statement might also require the SUPER privilege, as
described in Binary Logging of Stored Routines.

Example
-------

ALTER FUNCTION hello SQL SECURITY INVOKER;

URL: https://mariadb.com/kb/en/alter-function/https://mariadb.com/kb/en/alter-function/