Permission denied for SQL

Hi, I am following the Create SQL Query video from Tulip University After I created a function, and run a test query, I got an error “SQL Test Error
Error: [500] SQLQueryFailureError: The SQL query specified by the connector function failed to execute successfully: Postgres Connector encountered an error during query: permission denied for table work_order_ex” Can anyone give me help? Thanks!


In many occasions the SQL user login used to perform each query has a set of privileges set by the database server. It may be possible this specific SQL Connecter user login has attempted to access a table it does not have permission to access. I would recommend reaching out to your IT or the database server admin to request permission.

For more information on SQL Connector Authentication, please see this Tulip KB: How to Configure a Connector


1 Like