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.
dotConnect requires mysql.proc access ??
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).
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?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).
(Aside from upgrading of course