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 ?
Mysql – Unable to view MySQL db stored procedure
access-controlMySQLstored-procedures
Related Question
- Mysql – Execute grant for MySQL stored procedure revoked when stored procedure is altered
- Mysql – Update MySQL Stored Procedure Definers on shared environment
- Mysql – GRANT EXECUTE ON PROCEDURE unable to USE database
- MySQL: Is there a way to find out which user called stored procedure
- Sql-server – How to grant execute permissions to a stored procedure but not to the underlying databases
- Sql-server – Error when using OPENROWSET from a View as a nonsysadmin
Best Answer
use following command: