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:
DROP PROCEDURE IF EXISTS `tablename`$$
CREATE DEFINER=`user`@`192.168.0.100` PROCEDURE `tablename`(... 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)
From: Michael Dykman [mailto:mdykman@stripped]
Sent: December 11, 2009 9:50 AM
Subject: Re: Stored Proc's
of course. you can have entries
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
"May you live every day of your life."
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