List:General Discussion« Previous MessageNext Message »
From:wangxu Date:January 12 2006 7:54am
Subject:Re: question about "sql security"
View as plain text  
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
> 
> 
Thread
question about "sql security"wangxu4 Jan
  • Re: question about "sql security"Gleb Paharenko4 Jan
  • Re: question about "sql security"Peter Brawley4 Jan
  • Re: question about "sql security"wangxu12 Jan