错误代码:1305.FUNCTION或PROCEDURE不存在 [英] Error Code: 1305. FUNCTION or PROCEDURE does not exist

问题描述

因此，我正在MySQL中创建一个函数，然后尝试向用户授予使用该函数的权限，但无法这样做.这是我在做什么:

So I'm creating a function in MySQL and then trying to grant permission to use that function to a user and am unable to do so. Here's what I'm doing:

DELIMITER $$

USE rxhelp36_scbn$$

DROP FUNCTION IF EXISTS `businessDayDiff` $$
CREATE FUNCTION `businessDayDiff` (start DATETIME, stop DATETIME) RETURNS TINYINT
  NO SQL
BEGIN
  RETURN 5 * (DATEDIFF(stop, start) DIV 7) + MID('0123444401233334012222340111123400001234000123440', 7 * WEEKDAY(start) + WEEKDAY(stop) + 1, 1);
END $$

GRANT EXECUTE ON PROCEDURE rxhelp36_scbn.businessDayDiff TO 'myuser'@'localhost';

这是我遇到的错误:

Error Code: 1305. FUNCTION or PROCEDURE businessDayDiff does not exist

我不明白.我/just/定义了功能-它不存在吗?

I don't get it. I /just/ defined the function - how does it not exist?

推荐答案

显然，我需要执行GRANT EXECUTE ON FUNCTION而不是GRANT EXECUTE ON PROCEDURE.

Apparently I needed to do GRANT EXECUTE ON FUNCTION instead of GRANT EXECUTE ON PROCEDURE.

您会认为，如果GRANT EXECUTE ON PROCEDURE仅适用于PROCEDURE，则错误消息应该显示为错误代码:1305.PROCEDUREbusinessDayDiff不存在"，而不是"FUNCTION或PROCEDURE" ...

You'd think that if GRANT EXECUTE ON PROCEDURE only worked on PROCEDUREs that the error message ought to say "Error Code: 1305. PROCEDURE businessDayDiff does not exist" instead of "FUNCTION or PROCEDURE"...

这篇关于错误代码:1305.FUNCTION或PROCEDURE不存在的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！