I am using MyDac to connect MySQL and my Delphi Project, here is what is happening:
When I start the application, everything works fine but after some idle if I try to make a new search I get the error: 'Acess denied to user for routine myprocedure'
- I'm using roles to control the permissions
- I created a routine on mysql to run the select
After this, I need to restart the application