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" <gleb.paharenko@stripped>
To: <mysql@stripped>
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" <wangxu@stripped> 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
> / /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
> /_/ /_/\_, /___/\___\_\___/ 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/mysql?unsub=wangxu@stripped
>
>
