The syntax allows a single DEFINER clause. On Feb 22, 2010, at 7:45 AM, Steven Staples wrote:
> Well... let me finish... LOL (hit send some how...) > > I want to be able to have 2 different users access to a stored procedure... > > I've tried multiple ways to write it, and none of them seem to work. Does > anyone here know how to do this? > > CREATE (definer=`use...@`%`, definer=`sstapl...@`localhost`) PROCEDURE > `sstest`() > ..... > CREATE definer=`use...@`%` OR definer=`sstapl...@`localhost` PROCEDURE > `sstest`() > ..... > CREATE definer=`use...@`%` definer=`sstapl...@`localhost` PROCEDURE > `sstest`() > > > I can't think how it would be possible? Or is it? > > Steve > > > -----Original Message----- > From: Steven Staples [mailto:sstap...@mnsi.net] > Sent: February 22, 2010 8:42 AM > To: mysql@lists.mysql.com > Subject: declare multiple 'Definer' > > Good morning! > > I have been struggleing with creating a store procedure, that will allow 2 > users -- Paul DuBois Sun Microsystems / MySQL Documentation Team Madison, Wisconsin, USA www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org