From: Michael Dykman Date: December 11 2009 2:49pm Subject: Re: Stored Proc's List-Archive: http://lists.mysql.com/mysql/219664 Message-Id: <814b9a820912110649h1d42575fi2a7f3da0ebe45152@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable of course. you can have entries user@stripped user@stripped the only caveat is to make sure the reverse lookup of your client hosts works as expected as those are the names that mysql will apply at authentication time. - mkichael dykman On Fri, Dec 11, 2009 at 9:36 AM, Steve Staples wrote: > Silly question here... > > But can I have multiple definers for a stored proc, rather than allowing > `user`@`%`? =A0 basically, I want to only allow 1 user name, but from onl= y 2 > or 3 IP's. > > My Googleing didn't turn up anything of use, so now, I am here asking :) > > Thanks in advance! > > Steve Staples. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail= .com > > --=20 - michael dykman - mdykman@stripped "May you live every day of your life." Jonathan Swift Larry's First Law of Language Redesign: Everyone wants the colon.