debugging mysql stored function

Discussion of open issues, suggestions and bugs regarding database management and administration tools for MySQL
Post Reply
motney
Posts: 1
Joined: Thu 18 Oct 2007 13:55

debugging mysql stored function

Post by motney » Thu 18 Oct 2007 14:00

Trying to debug a mysql stored function from within visual studio using the MyDeveloper Tools, it returns a permissions error and I have not been able to figure out how to set the permissions properly.

When I select 'Compile for debugging' it returns SELECT command denied for table 'debuggings'

What permissions am I missing? The user account connected to mysql should already have full permissions.

Elias
Devart Team
Posts: 73
Joined: Tue 29 May 2007 14:02

Post by Elias » Fri 19 Oct 2007 10:34

We examined your situation and the most probable problem is that the user who deployed debug engine now doesn't have SELECT privilege on cr_debug database. And cr_debug procedures use DEFINER for execution.

So please redeploy the debug engine under your user account or root.

Elias
Devart Team
Posts: 73
Joined: Tue 29 May 2007 14:02

Post by Elias » Fri 19 Oct 2007 10:41

In the next build of MyDeveloper, cr_debug procedures will use invoker for execution.

Elias
Devart Team
Posts: 73
Joined: Tue 29 May 2007 14:02

Post by Elias » Fri 19 Oct 2007 11:47

We recieved your letter about the problem. And we need some more information. What privileges does your account have on database cr_debug?

Post Reply