【分享】MySQL账户执行存储过程的权限设置

damogyz

建立一个存储过程，调用该存储过程建立view，设置权限如下：

GRANT USAGE ON *.* TO 'user'@'hostname' IDENTIFIED BY 'PASSWORD';

GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, INDEX, ALTER, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE ON `mydbname`.* TO 'user'@'hostname' ;
GRANT SELECT ON `mysql`.`proc` TO 'user'@'hostname' ;
GRANT EXECUTE, ALTER ROUTINE ON PROCEDURE `mydbname`.`mynewview` TO 'user'@'hostname' ;