Thanks Bier. I see what you mean.
(As a rule we always use SQL SECURITY INVOKER)
David.
-----Original Message-----
From: Johan De Meersman [mailto:vegivamp@stripped]
Sent: Thursday, August 18, 2011 4:20 AM
To: David Lerer
Cc: mysql@stripped
Subject: Re: Concerned : Developer getting There is no 'root'@'%' registered error message
----- Original Message -----
> From: "David Lerer" <DLerer@stripped>
>
> 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
