Stored Proc"s

Silly question here...

But can I have multiple definers for a stored proc, rather than allowing
`user`@`%`? basically, I want to only allow 1 user name, but from only 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: http://lists.mysql.com/mysql?unsub=gcdmg-mysql-2@m.gmane.org

Re: Stored Proc"s

of course. you can have entries

user@domain1.me.com
user@xxx.foo.com

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@gmail.com

"May you live every day of your life."
Jonathan 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: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

RE: Stored Proc"s

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? Currently, i have =
this:

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 =
wildcarding
the domain. I 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@gmail.com]=20
Sent: December 11, 2009 9:50 AM
To: mysql@lists.mysql.com
Subject: Re: Stored Proc's

of course. you can have entries

user@domain1.me.com
user@xxx.foo.com

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 =
only 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@gmail.com

"May you live every day of your life."
Jonathan Swift

Larry's First Law of Language Redesign: Everyone wants the colon.

--=20
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: =
http://lists.mysql.com/mysql?unsub=3Dsstaples@mnsi.net

No virus found in this incoming message.
Checked by AVG - www.avg.com=20
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: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg

Re: Stored Proc"s

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 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@gmail.com]
> Sent: December 11, 2009 9:50 AM
> To: mysql@lists.mysql.com
> Subject: Re: Stored Proc's
>
> of course. =A0you can have entries
>
> user@domain1.me.com
> user@xxx.foo.com
>
> 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 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@gmail.com
>
> "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@gmail.com

"May you live every day of your life."
Jonathan 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: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg