Environment:
CentOS / Redhat 5
MySQL 5.1Grant Statement:
CREATE PROCEDURE getALLGF ...;
GRANT EXECUTE ON PROCEDURE getAllGF to 'User1'@'%';mysql.procs_priv: seems normal
...User1 ... getAllGF ... Execute ...SHOW GRANTS FOR User1: lower case !!???
...Execute on getallgf ...To User1 ...Execute by User1:
1. CALL getAllGF: No permissions
2. CALL getallgf: The procedure does NOT exist.
CentOS / Redhat 5
MySQL 5.1Grant Statement:
CREATE PROCEDURE getALLGF ...;
GRANT EXECUTE ON PROCEDURE getAllGF to 'User1'@'%';mysql.procs_priv: seems normal
...User1 ... getAllGF ... Execute ...SHOW GRANTS FOR User1: lower case !!???
...Execute on getallgf ...To User1 ...Execute by User1:
1. CALL getAllGF: No permissions
2. CALL getallgf: The procedure does NOT exist.
可以贴出你的以下信息,不要加工。直接贴就行了。show grants;
CALL getAllGF();
CALL getallgf();
show procedure status;