ALTER PROCEDURE

The ALTER PROCEDURE statement modifies the characteristics of an existing stored procedure, such as its security context or comment, without changing its logic.

Syntax

ALTER PROCEDURE proc_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 procedure. More than one change may be specified in an ALTER PROCEDURE statement. However, you cannot change the parameters or body of a stored procedure using this statement. To make such changes, you must drop and re-create the procedure using CREATE OR REPLACE PROCEDURE.

You must have the ALTER ROUTINE privilege for the procedure. By default, that privilege is granted automatically to the procedure creator. See Stored Routine Privileges.

Example

ALTER PROCEDURE simpleproc SQL SECURITY INVOKER;

See Also

• Stored Procedure Overview

• CREATE PROCEDURE

• SHOW CREATE PROCEDURE

• DROP PROCEDURE

• SHOW CREATE PROCEDURE

• SHOW PROCEDURE STATUS

• Stored Routine Privileges

• Information Schema ROUTINES Table

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