How "sql security" option restrict privileges? ----- Original Message ----- From: "Paul DuBois" <[EMAIL PROTECTED]> To: "wangxu" <[EMAIL PROTECTED]>; <mysql@lists.mysql.com> Sent: Wednesday, December 28, 2005 3:21 PM Subject:Re: how to use "sql security"
> At 15:17 +0800 12/28/05, wangxu wrote: > >User_one create a procdure named "proc" with option "sql security invoker". > > > >User_two only have "execute" privilege in the database that the "proc" in. > > > >But the User_two still call the "proc". > > > > > >What effect do the "sql security" option producing? > > proc runs with the invoker's privileges, that is, User_two's privileges. > > > -- > Paul DuBois, MySQL Documentation Team > Madison, Wisconsin, USA > MySQL AB, www.mysql.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >