Database bypassing any permissions in Metabase via SQlite attach
CVE-2022-24854
What is CVE-2022-24854?
Metabase is an open source business intelligence and analytics application. SQLite has an FDW-like feature called ATTACH DATABASE, which allows connecting multiple SQLite databases via the initial connection. If the attacker has SQL permissions to at least one SQLite database, then it can attach this database to a second database, and then it can query across all the tables. To be able to do that the attacker also needs to know the file path to the second database. Users are advised to upgrade as soon as possible. If you're unable to upgrade, you can modify your SQLIte connection strings to contain the url argument ?limit_attached=0, which will disallow making connections to other SQLite databases. Only users making use of SQLite are affected.
Affected Version(s)
metabase >= 1.41.0, < 1.41.7 < 1.41.0, 1.41.7
metabase >= 0.41.0, < 0.41.7 < 0.41.0, 0.41.7
metabase >= 1.42.0, < 1.42.4 < 1.42.0, 1.42.4