SQL SECURITY explanation in MySQL Store routines

Copyright statement: original works can be reproduced. During reprinting, you must mark the original source, author information, and this statement in hyperlink form. Otherwise, legal liability will be held.Http://yueliangdao0608.blog.51cto.com/397025/192886

 

Someone asked me a small question today.

I will explain the SQL SECURITY definition in store routines.

SQL SECURITY DEFINER indicates that the DEFINER must have relevant permissions.

SQL SECURITY INVOKER indicates that the caller has the relevant permissions.

It's easy. You can simply experiment and understand it. (For two users, one with the EXECUTE permission, the other with the create routine permission, and then each with the same call) I will not give an example here.