Overview
When performing SQL operations within Actions, an error is seen similar to:
Error: SELECT command denied to user <username>@<ip-address> for table <tablename>
Applies To
- Actions
- SQL Operations
- MySQL
Cause
This can be caused by a lack of permissions for the SQL user being used by the Action to make requests.
Solution
Check whether the SQL user being used by the Action has permission to access all tables required for the workflow or if there is a typo in the query specifying a non-existent table, for example.
If this error is seen, there should be connectivity between Auth0 servers and the SQL server, but if a different error is seen and the connection is refused, check the SQL server can accept requests from all of the tenant region’s outbound IPs: