ALTER PROCEDURE v16

Name

ALTER PROCEDURE — Modify an existing procedure.

ALTER PROCEDURE <procedure_name> <options> [RESTRICT]

Use the ALTER PROCEDURE statement to specify that a procedure is a SECURITY INVOKER or SECURITY DEFINER.

procedure_name

The (possibly schema-qualified) name of a stored procedure.

options can be:

[EXTERNAL] SECURITY DEFINER
Specify SECURITY DEFINER to execute the procedure with the privileges of the user that created the procedure. The EXTERNAL keyword is accepted for compatibility but ignored.
[EXTERNAL] SECURITY INVOKER
Specify SECURITY INVOKER to execute the procedure with the privileges of the user that's invoking the procedure. The EXTERNAL keyword is accepted for compatibility but ignored.

The RESTRICT keyword is accepted for compatibility but ignored.

This command specifies for the update_balance to execute with the privileges of the user invoking the procedure:

ALTER PROCEDURE update_balance SECURITY INVOKER;