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=gcdmg-mysql-2@m.gmane.org
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@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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=sstaples@mnsi.net
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=gcdmg-mysql-2@m.gmane.org
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=`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@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=gcdmg-mysql-2@m.gmane.org
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
> Well... let me finish... LOL =A0(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. =A0D=
oes
> anyone here know how to do this?
>
> CREATE (DEFINER=3D`user1`@`%`, DEFINER=3D`sstaples`@`localhost`) PROCEDUR=
E
> `sstest`()
> .....
> CREATE DEFINER=3D`user1`@`%` OR DEFINER=3D`sstaples`@`localhost` PROCEDUR=
E
> `sstest`()
> .....
> CREATE DEFINER=3D`user1`@`%` DEFINER=3D`sstaples`@`localhost` PROCEDURE
> `sstest`()
>
>
> I can't think how it would be possible? =A0 Or is it?
>
> Steve
>
>
> -----Original Message-----
> From: Steven Staples [mailto:sstaples@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
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dsstaples@mnsi=
..net
>
> 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: =A0 =A0http://lists.mysql.com/mysql?unsub=3Dmdykman@gmail=
..com
>
>
--=20
- michael dykman
- mdykman@gmail.com
May the Source be with you.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg