I am accessing the mysql DB via TOAD and I am getting the below error
"MySQL Database error - select command denied to user for table 'proc'"
When I click on the Procedures I dont see the list of SP's and see this error.
When I execute the below script, it reflects all the procedures in the DB.
select * from information_schema.routines
How do I aleviate this issue and compile procedures