User Authority

Symptoms

One or more SQL Macro returns the following error:

org.postgresql.util.PSQLException:
ERROR: permission denied

Cause

The database user associated with your Data Source does not have permission to the database or table. 

Resolution

Provide the user with the appropriate permissions.