ALTER FUNCTION

Change stored function characteristics. This statement allows modifying the security context or comments of a stored function without dropping it.

Syntax

ALTER FUNCTION func_name [characteristic ...]

characteristic:
    { CONTAINS SQL | NO SQL | READS SQL DATA | MODIFIES SQL DATA }
  | SQL SECURITY { DEFINER | INVOKER }
  | COMMENT 'string'

Description

This statement can be used to change the characteristics of a stored function. More than one change may be specified in an ALTER FUNCTION 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;

See Also

• CREATE FUNCTION

• SHOW CREATE FUNCTION

• DROP FUNCTION

• SHOW FUNCTION STATUS

• Information Schema ROUTINES Table

_{This page is licensed: GPLv2, originally from fill_help_tables.sql}