wuhong_CSDN
wuhong_CSDN
2017-05-27 15:54

mysql执行存储过程权限

5
  • mysql

存储过程执行报错

 ERROR 1227 (42000): Access denied; you need (at least one of) the SUPER privilege(s) for this operation
DELIMITER $$
USE `jta2db`$$
DROP PROCEDURE IF EXISTS `tblFinTotal_Procedure`$$
CREATE DEFINER=`jta2`@`%` PROCEDURE `tblFinTotal_Procedure`(IN table_name VARCHAR(20),IN input_time VARCHAR(20))
BEGIN
……………………

新手求解

  • 点赞
  • 回答
  • 收藏
  • 复制链接分享

3条回答

为你推荐