List:General Discussion« Previous MessageNext Message »
From:Johan De Meersman Date:August 18 2011 8:20am
Subject:Re: Concerned : Developer getting There is no 'root'@'%' registered error message
View as plain text  
----- 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