MySQL Forums
Forum List  »  Stored Procedures

Advanced Search
New Topic

Re: select privilege on proc table of mysql needed to execute an SP?
Posted by: Yvan Rodrigues
Date: October 19, 2008 12:30PM

This is an old article, but I'm going to answer this for anyone who has this problem. If you get this error it is because you don't have SELECT permission on mysql.proc. MySQL provides a workaround. Set UseProcedureBodies to false in your connection string or your MySqlConnectionStringBuilder instance.

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
select privilege on proc table of mysql needed to execute an SP?
16961
Chagh
August 28, 2005 02:58AM
Re: select privilege on proc table of mysql needed to execute an SP?
7564
Markus Popp
August 30, 2005 07:54AM
Re: select privilege on proc table of mysql needed to execute an SP?
14817
Anil Bhatia
January 03, 2006 05:41PM
Re: select privilege on proc table of mysql needed to execute an SP?
10418
Mayur Raval
August 10, 2006 10:44AM
Re: select privilege on proc table of mysql needed to execute an SP?
8274
Raymond Roelands
January 14, 2006 11:22AM
Re: select privilege on proc table of mysql needed to execute an SP?
5085
moserke
February 11, 2006 11:50PM
Re: select privilege on proc table of mysql needed to execute an SP?
4821
Carter Barry
February 15, 2006 07:17AM
Re: select privilege on proc table of mysql needed to execute an SP?
4682
Markus Popp
February 15, 2006 07:27AM
Re: select privilege on proc table of mysql needed to execute an SP?
5181
Carter Barry
February 15, 2006 10:21AM
Re: select privilege on proc table of mysql needed to execute an SP?
4079
Steve Baxter
April 06, 2006 02:27PM
Re: select privilege on proc table of mysql needed to execute an SP?
4036
Fred Nelson
April 09, 2006 09:41PM
Re: select privilege on proc table of mysql needed to execute an SP?
8584
John Dye
May 16, 2006 10:40PM
Re: select privilege on proc table of mysql needed to execute an SP?
4294
Salomon Herrera
July 21, 2006 09:17PM
Re: select privilege on proc table of mysql needed to execute an SP?
6001
Yvan Rodrigues
October 19, 2008 12:30PM
Re: select privilege on proc table of mysql needed to execute an SP?
4519
rick blouch
January 06, 2009 09:54PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.