As a root user i did this: GRANT DELETE, SELECT, INSERT, UPDATE, EXECUTE ON dbName.* TO 'user'@'localhost' IDENTIFIED BY 'apassword';
In 'dbName' i created a procedure 'proc_name' with definer set to 'user'@'localhost'.
Similarly i create a function 'func_name' with definer set to 'user'@'localhost'.
Now the issue is, i able to do select func_name(); but i am not able to call the procedure proc_name() when i did :
call proc_name(), i get the error:
ERROR 1044 (42000): Access denied for user 'user'@'localhost' to database 'dbName'
Any pointers to the solution would be appreciated.
Aucun commentaire:
Enregistrer un commentaire