List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:December 11 2009 7:10pm
Subject:Re: Stored Proc's
View as plain text  
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?   Currently, i have this:
>
> DELIMITER $$
> USE `tablename`$$
> DROP PROCEDURE IF EXISTS `tablename`$$
> CREATE DEFINER=`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@stripped]
> Sent: December 11, 2009 9:50 AM
> To: mysql@stripped
> Subject: Re: Stored Proc's
>
> 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 <sstaples@stripped> wrote:
>> 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=1
>>
>>
>
>
>
> --
>  - 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.
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
> 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:    http://lists.mysql.com/mysql?unsub=1
>
>



-- 
 - 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.
Thread
Stored Proc'sSteve Staples11 Dec
  • Re: Stored Proc'sMichael Dykman11 Dec
    • RE: Stored Proc'sSteven Staples11 Dec
      • Re: Stored Proc'sMichael Dykman11 Dec