How to auto refresh public dashboard for users with readonly permission?


I’ve found some posts about refreshing. Indeed it is really confusing. My question is a more specific one.

Suppose there are two GROUPs of users: default / viewer. Default group has full permission to given data source, while viewer group only has read permission. Now one user in default group created a public dashboard, how to make users in viewer group to refresh/auto-refresh this dashboard? When they click “refresh” button, Redash complains about no permission to read.