Some of my users are reporting that they don't see the "explore results" buttons that allow for easy sorting and filtering of query results, especially when dealing with reports based on native sql queries.
I do see it, so I just played around with the permissions. What I found out so far, is that the "explore results" button only seems to appear when groups have "Native query editing" permissions. This would be fine, but granting them those rights also forces you to grant them complete access to the database the native query runs on, which is not fine.
Is there any way for me to make the "explore results" button visible to my users without granting them access to the entire database schema?