>I refer a question about "sql security" option of create procedure syntax
>at 2005-12. But i can't quite understood with that answer.
>Can you give me a example to describe the effect of set "sql security"
SQL SECURITY INVOKER
SQL SECURITY (compliance with SQL2003) specifies whether the user
of the author (DEFINER) or the INVOKER apply; the default is DEFINER.
MySQL has supported GRANTs for CREATE, ALTER and EXECUTE. The first
includes the latter two.
If binary logging in enabled, see
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.371 / Virus Database: 267.14.11/219 - Release Date: 1/2/2006