List:General Discussion« Previous MessageNext Message »
From:David Lerer Date:August 18 2011 10:11am
Subject:RE: Concerned : Developer getting There is no 'root'@'%' registered error message
View as plain text  
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
Thread
Concerned : Developer getting There is no 'root'@'%' registered errormessageBrent Clark17 Aug
Re: Concerned : Developer getting There is no 'root'@'%' registerederror messageJohnny Withers17 Aug
  • Re: Concerned : Developer getting There is no 'root'@'%' registerederror messageBrent Clark17 Aug
    • Re: Concerned : Developer getting There is no 'root'@'%' registered error messageJohan De Meersman17 Aug
      • RE: Concerned : Developer getting There is no 'root'@'%' registered error messageDavid Lerer17 Aug
        • Re: Concerned : Developer getting There is no 'root'@'%' registered error messageJohan De Meersman18 Aug
          • RE: Concerned : Developer getting There is no 'root'@'%' registered error messageDavid Lerer18 Aug
            • Re: Concerned : Developer getting There is no 'root'@'%' registered error messageJohan De Meersman18 Aug
Re: Concerned : Developer getting There is no 'root'@'%' registerederror messageJohnny Withers17 Aug
  • Re: Concerned : Developer getting There is no 'root'@'%' registerederror messageJon Siebert17 Aug