RE: declare multiple 'Definer'

2010-02-22 Thread Steven Staples
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...@`%`,

Re: declare multiple 'Definer'

2010-02-22 Thread Paul DuBois
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

Re: declare multiple 'Definer'

2010-02-22 Thread Michael Dykman
You don't need multiple definers to have multiple users. Why did you want 2 definers? - michael dykman On Mon, Feb 22, 2010 at 8:45 AM, Steven Staples sstap...@mnsi.net wrote: Well... let me finish... LOL  (hit send some how...) I want to be able to have 2 different users access to a