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 either CREATE OR REPLACE PROCEDURE (since
MariaDB 10.1.3) or DROP PROCEDURE and CREATE PROCEDURE (MariaDB 10.1.2 and
before).

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;

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