Mysql – Unable to view MySQL db stored procedure


We have many stored procedures created with SQL SECURITY DEFINER by user A
Now user B is responsible for maintaining some of the stored procedure. However user B is unable to view/update the stored procedure from workbench since the definer is set to A. Is there an way to give A and B access to the stored procedure at the same time ?

Best Answer

use following command:

GRANT EXECUTE ON dbname.* TO 'user'@'%';