How to resolve a Permission denied error - 10.x

Owned by Smita Nair
Feb 18, 2020

Symptoms

One or more SQL macros return the following error:

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

Grant the appropriate permissions to the user.