List:General Discussion« Previous MessageNext Message »
From:Michael Dykman Date:February 22 2010 8:55pm
Subject:Re: declare multiple 'Definer'
View as plain text  
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 <sstaples@stripped> 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=`user1`@`%`, DEFINER=`sstaples`@`localhost`) PROCEDURE
> `sstest`()
> .....
> CREATE DEFINER=`user1`@`%` OR DEFINER=`sstaples`@`localhost` PROCEDURE
> `sstest`()
> .....
> CREATE DEFINER=`user1`@`%` DEFINER=`sstaples`@`localhost` PROCEDURE
> `sstest`()
>
>
> I can't think how it would be possible?   Or is it?
>
> Steve
>
>
> -----Original Message-----
> From: Steven Staples [mailto:sstaples@stripped]
> Sent: February 22, 2010 8:42 AM
> To: mysql@stripped
> Subject: declare multiple 'Definer'
>
> Good morning!
>
> I have been struggleing with creating a store procedure, that will allow 2
> users
>
>
> --
> 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.733 / Virus Database: 271.1.1/2683 - Release Date: 02/21/10
> 14:34:00
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
>
>



-- 
 - michael dykman
 - mdykman@stripped

 May the Source be with you.
Thread
declare multiple 'Definer'Steven Staples22 Feb
  • RE: declare multiple 'Definer'Steven Staples22 Feb
    • Re: declare multiple 'Definer'Paul DuBois22 Feb
    • Re: declare multiple 'Definer'Michael Dykman22 Feb