----- 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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
