Explanation of MySQL stored procedure-definer and Invoker

"Explanations of Definer and Invoker"

When you create a stored procedure, you can specify the SQL security property, set to Definer or Invoker, to tell MySQL whether the stored procedure is executed with the permission of the Definer user or by the caller's permission.

By default, the Definer method is used, at which point the user calling the stored procedure must have EXECUTE permission for the stored procedure, and definer the specified user must be a user that exists in the Mysql.user table.

Definer mode, the default Definer=current_user, when the stored procedure executes, MySQL checks definer defined user ' user_name ' @ ' host_name ' permissions;

In Invoker mode, when a stored procedure executes, the permissions of the stored procedure caller are checked.

Explanation of MySQL stored procedure-definer and Invoker