Scenario: User has view permissions on a report and granular data permissions on specific table. And report 3 filters
Issues1: With default selection report refreshes successfully, but when user updates one of the filters and refreshes report throws error that you don't have permissions. And when the user refreshes entire page with updated filter values, report runs fine.
Ask: Do user requires native query permissions to modify/update filter values?
issue2: With same configuration, user able to view report and report being downloaded in to csv format, it shows ""error_type":"missing-required-permissions" error.
Ask: In this scenario, granular permissions are not working, when i grant native query and unrestricted access on underlying database, it works. But thats not desired permissions we want to grant, how to fix?
Here is our deployment info:
{
"browser-info": {
"language": "en-US",
"platform": "Win32",
"userAgent": "Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/112.0.0.0 Safari/537.36",
"vendor": "Google Inc."
},
"system-info": {
"file.encoding": "UTF-8",
"java.runtime.name": "OpenJDK Runtime Environment",
"java.runtime.version": "11.0.14.1+1",
"java.vendor": "Eclipse Adoptium",
"java.vendor.url": "https://adoptium.net/",
"java.version": "11.0.14.1",
"java.vm.name": "OpenJDK 64-Bit Server VM",
"java.vm.version": "11.0.14.1+1",
"os.name": "Linux",
"os.version": "5.10.162+",
"user.language": "en",
"user.timezone": "UTC"
},
"metabase-info": {
"databases": [
"presto-jdbc",
"mysql"
],
"hosting-env": "unknown",
"application-database": "mysql",
"application-database-details": {
"database": {
"name": "MySQL",
"version": "5.7.28-log"
},
"jdbc-driver": {
"name": "MariaDB Connector/J",
"version": "2.6.2"
}
},
"run-mode": "prod",
"version": {
"date": "2022-02-28",
"tag": "v0.42.2",
"branch": "release-x.42.x",
"hash": "d6ff494"
},
"settings": {
"report-timezone": null
}
}
}