(mysql.info) stored-procedure-privileges
Info Catalog
(mysql.info) stored-procedures
(mysql.info) stored-procedures
(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-procedures
(mysql.info) stored-procedure-syntax
automatically generated byinfo2html