List:General Discussion« Previous MessageNext Message »
From:Steven Staples Date:February 22 2010 1:45pm
Subject:RE: declare multiple 'Definer'
View as plain text  
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

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