Sage 300 Version: 23.1.1.72

I am working on a simple interaction between an Excel spreadsheet that extracts data from specific tables within the Sage 300 database.  With my "admin" credentials it works but with a specific user's credentials it fails so it makes sense this user does not have rights to access this data.  This is Payroll data and the user does have access to the PR Role which I thought would cover it but nope, still failing.

The tables are PRM_MASTER__EMPLOYEE and PRM_MASTER__EMPLOYEE_PAY on an Excel query that just SELECTS data from columns in those 2 tables for a simple query of payroll information for each user.  It's quite a simple SELECT statement in the Excel query.

So how can I make this happen as I don't want to give user an "admin" right/role?