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 <sstap...@mnsi.net> wrote: > They are actual IP's, not domain names. > > So it would be like `us...@`192.168.0.100` and `us...@`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=`us...@`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:mdyk...@gmail.com] > Sent: December 11, 2009 9:50 AM > To: mysql@lists.mysql.com > Subject: Re: Stored Proc's > > of course. you can have entries > > u...@domain1.me.com > u...@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 <sstap...@mnsi.net> wrote: >> Silly question here... >> >> But can I have multiple definers for a stored proc, rather than allowing >> `us...@`%`? 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=mdyk...@gmail.com >> >> > > > > -- > - michael dykman > - mdyk...@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=sstap...@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: http://lists.mysql.com/mysql?unsub=mdyk...@gmail.com > > -- - michael dykman - mdyk...@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=arch...@jab.org
