search

hlapidez / common-schema

Automatically exported from code.google.com/p/common-schema
0 stars 0 forks source link

sql_grants: incorrect GRANT syntax for stored routines #30

Closed GoogleCodeExporter closed 9 years ago

GoogleCodeExporter commented 9 years ago 
GRANT USAGE ON *.* TO 'world_user'@'localhost';
GRANT EXECUTE, ALTER ROUTINE ON FUNCTION `sakila`.`get_customer_balance` TO 
'world_user'@'localhost' WITH GRANT OPTION;

mysql> SELECT sql_grant FROM sql_grants WHERE grantee = 
"'world_user'@'localhost'" \G

sql_grant: GRANT USAGE ON *.* TO 'world_user'@'localhost' IDENTIFIED BY 
PASSWORD ''
sql_grant: GRANT ALTER ROUTINE, EXECUTE ON `sakila`.`get_customer_balance` TO 
'world_user'@'localhost' WITH GRANT OPTION

"ON" stored routine should include "FUNCTION" or "PROCEDURE"

Original issue reported on code.google.com by shlomi.n...@gmail.com on 18 Nov 2012 at 6:49

GoogleCodeExporter commented 9 years ago 
Fixed in revision 372
Need to add tests

Original comment by shlomi.n...@gmail.com on 18 Nov 2012 at 7:11