Devart Forums

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.

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.

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

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