Symptoms
One or more SQL Macro returns Macros return the following error:
| Code Block |
|---|
org.postgresql.util.PSQLException: ERROR: permission denied |
Cause
The database user associated with your Data Source does not have permission to access the database or table.
Resolution
Provide the user with the appropriate permissionsGrant appropriate permissions to the user.