获取权限错误和"function does not exist"错误

Question

我得到一个错误，Create函数必须是查询批处理中的第一条语句，并且我必须声明@userfirstname和@userlastname。我错过了什么？

Drop function if exists dbo.udf_getUserID;
CREATE FUNCTION dbo.udf_getUserID(@userfirstname NVarchar (25), @userlastname NVarchar (50))
RETURNS INT
AS
BEGIN
DECLARE @PbUser_id INT;
SELECT  @PbUser_id=PbUser_id
FROM PbUser
WHERE userFirstName =@userfirstname AND
userLastName =@userlastname;
IF @PbUser_id is Null
set @PbUser_id =-1;
return @PbUser_id;
END
SELECT dbo.udf_getUserID('Pace','Wasden');

Answer 1

请尝试使用此

GRANT EXECUTE ON FUNCTION <Function Name> TO '<username>'@'localhost';