Error: SELECT Command Denied to User Seen in Action Logs

Knowledge Solutions
,
1

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: