(mysql.info) stored-procedure-privileges

(mysql.info) stored-procedure-syntax

 
 17.1 Stored Routines and the Grant Tables
 =========================================
 
 Stored routines require the `proc' table in the `mysql' database. This
 table is created during the MySQL 5.0 installation procedure. If you are
 upgrading to MySQL 5.0 from an earlier version, be sure to update your
 grant tables to make sure that the `proc' table exists. See 
 mysql-upgrade.
 
 The server manipulates the `mysql.proc' table in response to statements
 that create, alter, or drop stored routines. It is not supported that
 the server will notice manual manipulation of this table.
 
 Beginning with MySQL 5.0.3, the grant system takes stored routines into
 account as follows:
 
    * The `CREATE ROUTINE' privilege is needed to create stored routines.
 
    * The `ALTER ROUTINE' privilege is needed to alter or drop stored
      routines. This privilege is granted automatically to the creator
      of a routine.
 
    * The `EXECUTE' privilege is required to execute stored routines.
      However, this privilege is granted automatically to the creator of
      a routine. 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.

Info Catalog

(mysql.info) stored-procedures

(mysql.info) stored-procedure-syntax

automatically generated byinfo2html