how to use sql security

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?

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

Re: how to use sql security

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