non-root users cannot use store procedures via Workbench/Navicat interface

[Imran980]

We have stored procedures in our database, initially created with the root user as the definer. While all users can invoke these procedures using the CALL method, non-root users face limitations when trying to access them through UI tools like Workbench or Navicat. These users can perform actions on tables and views without issue, but they encounter restrictions with procedures.

In other words, my users can execute, alter or create procedures in workbench but they cannot execute or alter existing procedures using the Workbench interface options or menu. Our users find it workbench easy to use when running procedures but the interface would pop up a window in case of necessary parameters.

We have given all the necessary privileges like CREATE ROUTINE, ALTER ROUTINE, EXECUTE along with all privileges but they still cannot do.

I also tried using non-root user with enough privileges to create the procedures but they non-owner users are still unable to use the Workbench menu.

Please give me some guidance on where I am doing wrong and what should I do.

Thank you!

[robertcarlos]

Hi @Imran980,

Welcome to Google Cloud Community!

Have you tried configuring your connection again by following this link on connecting with MySQL Workbench? In this way we would determine where the issue lies if it's within Google Cloud SQL's end. 

Have you also considered using Google Cloud MySQL client? You may check out the steps on how to connect using a MySQL client.

Hope these help.

[Imran980]

Thanks Robert for your response. We are not using SSH in Workbench. Yes, we tried MySQL client but we are having issues only in graphical tools. Even in GUI tools our users can execute procedures with CALL command but cannot do that in the GUI feature. And it does not seem like a privileges issue.