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/