dotConnect requires mysql.proc access ??

dotConnect requires mysql.proc access ??

Postby 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.
karim
 
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Postby 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).
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16

Postby 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 :)
karim
 
Posts: 9
Joined: Mon 04 Feb 2008 20:44

Postby AndreyR » Thu 16 Jun 2011 13:12

Yes, you are correct in your assumption.
AndreyR
Devart Team
 
Posts: 2919
Joined: Mon 07 Jul 2008 13:16


Return to dotConnect for MySQL