GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO 'aivanov';
GRANT SELECT ON db1.* TO 'aivanov';
GRANT SELECT, INSERT, UPDATE ON db1.point TO 'aivanov';
FLUSH PRIVILEGES;

CREATE PROCEDURE db1.a_grant_for_user(IN _username VARBINARY(255))
  SQL SECURITY INVOKER
BEGIN

GRANT CREATE TEMPORARY TABLES, LOCK TABLES ON *.* TO _userName;
GRANT SELECT ON db1.* TO _userName;
GRANT SELECT, INSERT, UPDATE ON db1.point TO _userName;
FLUSH PRIVILEGES;
END

set @q=concat('GRANT EXECUTE     ON PROCEDURE db1.new_proc1_test TO ',0x27, 'aivanov',0x27);
PREPARE stm FROM @q;