thank you gleb. But,the "sql security"d description in the manual is not particular. I mistaked the concept. I understand the limit is procedure limit but not database object limit.
So,i believe this concept should more definitude if you add the example in this part of manual. ------------------------------------------------------------- CREATE PROCEDURE p26 () SQL SECURITY INVOKER SELECT COUNT(*) FROM t // CREATE PROCEDURE p27 () SQL SECURITY DEFINER SELECT COUNT(*) FROM t // GRANT INSERT ON db5.* TO peter; // ------------------------------------------------------------- ----- Original Message ----- From: "Gleb Paharenko" <[EMAIL PROTECTED]> To: <mysql@lists.mysql.com> Sent: Wednesday, January 04, 2006 5:22 PM Subject: Re: question about "sql security" > Hello. > > In my opinion, a good description can be found here: > http://dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html > > > "wangxu" <[EMAIL PROTECTED]> wrote: > > > -- > For technical support contracts, goto https://order.mysql.com/?ref=ensita > This email is sponsored by Ensita.NET http://www.ensita.net/ > __ ___ ___ ____ __ > / |/ /_ __/ __/ __ \/ / Gleb Paharenko > / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] > /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET > <___/ www.mysql.com > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >
