From: Michael Dykman
Date: December 11 2009 7:10pm
Subject: Re: Stored Proc's
List-Archive: http://lists.mysql.com/mysql/219670
Message-Id: <814b9a820912111110u55ac40f8i49a3fd44940cfdcc@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

Yeah,  that's exactly right


You can also do some partials like

'user'@'192.168.2.%'

 - michael dykman


On Fri, Dec 11, 2009 at 11:33 AM, Steven Staples <sstaples@stripped> wrote:
> They are actual IP's, not domain names.
>
> So it would be like `user`@`192.168.0.100` and `user`@`192.168.0.101`... =
so
> how would I go about putting that in the definer? =A0 Currently, i have t=
his:
>
> DELIMITER $$
> USE `tablename`$$
> DROP PROCEDURE IF EXISTS `tablename`$$
> CREATE DEFINER=3D`user`@`192.168.0.100` PROCEDURE `tablename`(... etc etc
> etc...
>
>
> Sorry if this is sounding dumb, I've only just started using stored procs
> (and i love them), and i have only seen examples with 1 user, or wildcard=
ing
> the domain. =A0I would also like to know how to do it for any/all users (=
but
> that is not what I am needing now)
>
> Steven Staples
>
>
> -----Original Message-----
> From: Michael Dykman [mailto:mdykman@stripped]
> Sent: December 11, 2009 9:50 AM
> To: mysql@stripped
> Subject: Re: Stored Proc's
>
> of course. =A0you 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.
>
>
> =A0- mkichael dykman
>
>
>
> On Fri, Dec 11, 2009 at 9:36 AM, Steve Staples <sstaples@stripped> 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 on=
ly 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@gmai=
l.com
>>
>>
>
>
>
> --
> =A0- michael dykman
> =A0- mdykman@stripped
>
> "May you live every day of your life."
> =A0 =A0Jonathan Swift
>
> Larry's First Law of Language Redesign: Everyone wants the colon.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dsstaples@mnsi=
.net
>
> No virus found in this incoming message.
> Checked by AVG - www.avg.com
> Version: 9.0.709 / Virus Database: 270.14.101/2555 - Release Date: 12/11/=
09
> 05:06:00
>
>
> --
> 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.