User can't refresh some Query Results queries

[arikfr]

Issue Summary

User A has access to Data Source A and the Query Results data source.
User B has only access to the Query Results data source.

User A creates a Query Results query which uses Data Source A.

Current behavior: User B can't refresh this query, because they don't have access to Data Source A.

Expected behavior: User B should be able to refresh this query, just like an external user can using the query API key.

[arikfr]

Possible solution:

• "Compute" all the queries this query accesses before applying parameters.
• Make sure query creator has access to all of them.
• Allow query viewer to access them.

[rauchy]

Is there anything left to be done here or did #4112 solve this entirely?

[arikfr]

Currently we support the case where you have Read Only access to all the data sources involved. We should probably support the case where you have Read Only access only to the Query Results data source.