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
