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 ?
use following command:
GRANT EXECUTE ON dbname.* TO 'user'@'%';