2.3.2 ALTER PROCEDURE

Table of Contents Previous Next


2 The SQL Language : 2.3 SQL Commands : 2.3.2 ALTER 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 specifies the (possibly schema-qualified) name of a stored procedure.
options may be:
Specify SECURITY DEFINER to instruct the server to execute the procedure with the privileges of the user that created the procedure. The EXTERNAL keyword is accepted for compatibility, but ignored.
Specify SECURITY INVOKER to instruct the server to execute the procedure with the privileges of the user that is invoking the procedure. The EXTERNAL keyword is accepted for compatibility, but ignored.
The RESTRICT keyword is accepted for compatibility, but ignored.
The following command specifies that the update_balance procedure should execute with the privileges of the user invoking the procedure:

2 The SQL Language : 2.3 SQL Commands : 2.3.2 ALTER PROCEDURE

Table of Contents Previous Next