"Don" <don81846@NO_CaCa.Earthlink.net> wrote in message
news:re********************************@4ax.com...
DROP PROCEDURE IF EXISTS `mailmsgs`.`sp_AddNew` $$
CREATE PROCEDURE `mailmsgs`.`sp_AddNew` (
....
Error: 1044 SQLSTATE: 42000 (ER_DBACCESS_DENIED_ERROR)
Message: Access denied for user '%s'@'%s' to database '%s'
I don't get this error when I execute other queries against the same
db and table.
http://dev.mysql.com/doc/refman/5.0/...procedure.html
This page says:
"These statements create stored routines. As of MySQL 5.0.3, to use them, it
is necessary to have the CREATE ROUTINE privilege."
http://dev.mysql.com/doc/refman/5.0/...-provided.html
This page says:
"The CREATE ROUTINE privilege is needed for creating stored routines
(functions and procedures). ALTER ROUTINE privilege is needed for altering
or dropping stored routines, and EXECUTE is needed for executing stored
routines."
See this page for more information about the privilege system and how to go
about granting privileges to database users:
http://dev.mysql.com/doc/refman/5.0/...ge-system.html
Regards,
Bill K.