From: Johan De Meersman Date: August 18 2011 8:20am Subject: Re: Concerned : Developer getting There is no 'root'@'%' registered error message List-Archive: http://lists.mysql.com/mysql/225557 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit ----- Original Message ----- > From: "David Lerer" > > Correct me if I am wrong, but my impression is that usage of > "DEFINER=" 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