Thanks Bier. I see what you mean. (As a rule we always use SQL SECURITY INVOKER) David.
-----Original Message----- From: Johan De Meersman [mailto:vegiv...@tuxera.be] Sent: Thursday, August 18, 2011 4:20 AM To: David Lerer Cc: mysql@lists.mysql.com Subject: Re: Concerned : Developer getting There is no 'root'@'%' registered error message ----- Original Message ----- > From: "David Lerer" <dle...@us.univision.com> > > Correct me if I am wrong, but my impression is that usage of > "DEFINER=<user>" in stored procedures has no impact on runtime and > is actually optional. > (not to be confused with the clause SQL SECURITY INVOKER which is > crucial.) You can also say SQL SECURITY DEFINER, which makes the procedure run with the privileges of the user who defined it. At that point, the definer becomes very relevant indeed :-) -- Bier met grenadyn Is als mosterd by den wyn Sy die't drinkt, is eene kwezel Hy die't drinkt, is ras een ezel
