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?
17685
Chagh
August 28, 2005 02:58AM
Re: select privilege on proc table of mysql needed to execute an SP?
7914
Markus Popp
August 30, 2005 07:54AM
Re: select privilege on proc table of mysql needed to execute an SP?
15124
Anil Bhatia
January 03, 2006 05:41PM
Re: select privilege on proc table of mysql needed to execute an SP?
10747
Mayur Raval
August 10, 2006 10:44AM
Re: select privilege on proc table of mysql needed to execute an SP?
8634
Raymond Roelands
January 14, 2006 11:22AM
Re: select privilege on proc table of mysql needed to execute an SP?
5324
moserke
February 11, 2006 11:50PM
Re: select privilege on proc table of mysql needed to execute an SP?
5085
Carter Barry
February 15, 2006 07:17AM
Re: select privilege on proc table of mysql needed to execute an SP?
4925
Markus Popp
February 15, 2006 07:27AM
Re: select privilege on proc table of mysql needed to execute an SP?
5459
Carter Barry
February 15, 2006 10:21AM
Re: select privilege on proc table of mysql needed to execute an SP?
4345
Steve Baxter
April 06, 2006 02:27PM
Re: select privilege on proc table of mysql needed to execute an SP?
4369
Fred Nelson
April 09, 2006 09:41PM
Re: select privilege on proc table of mysql needed to execute an SP?
9225
John Dye
May 16, 2006 10:40PM
Re: select privilege on proc table of mysql needed to execute an SP?
4556
Salomon Herrera
July 21, 2006 09:17PM
Re: select privilege on proc table of mysql needed to execute an SP?
6378
Yvan Rodrigues
October 19, 2008 12:30PM
Re: select privilege on proc table of mysql needed to execute an SP?
4828
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.