dotConnect requires mysql.proc access ??

karim · Post by **karim** » Thu 16 Jun 2011 10:38

Why isn't dotConnect getting the info from the information_schema?
Error: "SELECT COMMAND DENIED TO USER '@ FOR TABLE PROC.
Problem occurs when trying to add an Entity Data Model.

MySQL version is 5.0.51a
Using the latest dotConnect (Trial) version.

AndreyR · Post by **AndreyR** » Thu 16 Jun 2011 12:31

The problem is the fact that the information about the parameters of the stored procedure is stored in the mysql.proc table, so we don't have a possibility to add the procedures.
There is no such problem in MySQL servers since 5.5.3, because of changes in the information_schema structure (specifically, the Parameters table).

karim · Post by **karim** » Thu 16 Jun 2011 12:37

AndreyR wrote:The problem is the fact that the information about the parameters of the stored procedure is stored in the mysql.proc table, so we don't have a possibility to add the procedures.
There is no such problem in MySQL servers since 5.5.3, because of changes in the information_schema structure (specifically, the Parameters table).

So the workaround is granting select privileges on the mysql db for the user?

(Aside from upgrading of course

AndreyR · Post by **AndreyR** » Thu 16 Jun 2011 13:12

Yes, you are correct in your assumption.