>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" >option ?
CREATE PROCEDURE ... SQL SECURITY INVOKER ... SQL SECURITY (compliance with SQL2003) specifies whether the user privileges of the author (DEFINER) or the INVOKER apply; the default is DEFINER. Since 5.0.3, MySQL has supported GRANTs for CREATE, ALTER and EXECUTE. The first includes the latter two. If binary logging in enabled, see http://dev.mysql.com/doc/refman/5.0/en/stored-procedure-logging.html. PB ----- -- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]