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=arch...@jab.org
