Devart Forums

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.

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).

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

Yes, you are correct in your assumption.