创建存储例程需要 CREATE ROUTINE 权限。The CREATE ROUTINE privilege is needed to create stored routines.

修改或删除存储例程需要 ALTER ROUTINE 权限。如果需要，这个权限会自动授予例程的创建者，当例程被删除时，这个权限也会从创建者那里撤销。The ALTER ROUTINE privilege is needed to alter or drop stored routines. This privilege is granted automatically to the creator of a routine if necessary, and dropped from the creator when the routine is dropped.

执行存储例程需要EXECUTE权限。然而，如果需要，这个权限会自动授予例程的创建者（当例程被删除时，该权限也会从创建者处撤销）。此外，例程的默认SQL SECURITY特性是DEFINER，这使得有权访问与该例程相关的数据库的用户能够执行该例程。The EXECUTE privilege is required to execute stored routines. However, this privilege is granted automatically to the creator of a routine if necessary (and dropped from the creator when the routine is dropped). Also, the default SQL SECURITY characteristic for a routine is DEFINER, which enables users who have access to the database with which the routine is associated to execute the routine.

如果 automatic_sp_privileges 系统变量为 0，则 EXECUTE 和 ALTER ROUTINE 权限不会自动授予给例程创建者，也不会自动从其移除。If the automatic_sp_privileges system variable is 0, the EXECUTE and ALTER ROUTINE privileges are not automatically granted to and dropped from the routine creator.

例程的创建者是用于执行 CREATE 语句的账户。这可能与例程定义中作为 DEFINER 指定的账户不同。The creator of a routine is the account used to execute the CREATE statement for it. This might not be the same as the account named as the DEFINER in the routine definition.

被指定为例程 DEFINER 的帐户可以查看所有例程属性，包括其定义。因此，该帐户可以完全访问例程输出，包括通过以下方式生成的输出：The account named as a routine DEFINER can see all routine properties, including its definition. The account thus has full access to the routine output as produced by:

对于非例程 DEFINER 的帐户，访问例程属性取决于授予该帐户的权限：For an account other than the account named as the routine DEFINER, access to routine properties depends on the privileges granted to the account: