How to resolve a Permission denied error - 10.x

Symptoms

One or more SQL macros return the following error:

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.