CVE-2022-24854
Official description Straight from the sourceThe vendor's or NVD's own wording, published unedited. Authoritative, but often terse — it says what broke, rarely what to do.
NVD · uneditedMetabase 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.
Technical summary Written by usOur analysis, written from the advisory, the CVSS vector and the affected-version data. It adds context the advisory leaves out, and never invents facts that are not in the source.
dbcve analysis · high confidenceMetabase's SQLite integration allows the ATTACH DATABASE feature, which permits connecting multiple SQLite databases through the initial connection. An attacker with SQL permissions to any SQLite database can attach additional SQLite databases (if they know the file path) and query across all tables, enabling unauthorized data access to otherwise inaccessible databases.
Verify against the referenced sources before acting — the references below are authoritative for this CVE, this summary is not.
Affected products & versions What the vendor confirmedThe version ranges the vendor confirmed as vulnerable. If your version sits inside a range here, treat yourself as exposed until you have upgraded.
NVD · CPE data>= 0.41.0, < 0.41.7>= 0.42.0, < 0.42.4>= 1.41.0, < 1.41.7>= 1.42.0, < 1.42.4CVSS breakdown How the score is builtThe industry scoring standard. It rates how the flaw is reached, what it takes to exploit, and what an attacker gains — the score is derived from those, not the other way round.
From the vector- Attack vector
- Network
- Complexity
- Low
- Privileges
- Low
- User interaction
- None
- Scope
- Unchanged
- Confidentiality
- High
- Integrity
- High
- Availability
- High
CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
Am I affected? How to checkSteps we derive from the advisory and the affected-version data, so you can decide whether this CVE reaches your setup. They are a guide, not a scan — your own configuration is the authority.
dbcve checksWork through these to decide whether this CVE applies to you.
-
Identify Metabase installation and versionCheck the Metabase admin panel under 'About Metabase' or inspect the JAR filename/application logs to determine the installed version numberAffected if The installed version falls within >= 0.41.0 and < 0.41.7, >= 0.42.0 and < 0.42.4, >= 1.41.0 and < 1.41.7, or >= 1.42.0 and < 1.42.4
-
Confirm SQLite database drivers are in useNavigate to Metabase admin panel, go to 'Databases', and review the list of configured database connections to identify any SQLite databasesAffected if At least one SQLite database connection exists in the Metabase instance
-
Verify SQLite connection configurationInspect the SQLite database connection settings in Metabase admin panel, specifically examining the connection string or JDBC URL configurationAffected if The SQLite connection URL does not contain the 'limit_attached=0' parameter, meaning the ATTACH DATABASE feature remains enabled
-
Check for unauthorized database access riskReview the SQL query logs or audit logs if available, looking for any ATTACH DATABASE statements executed against SQLite connectionsAffected if ATTACH DATABASE queries have been executed against SQLite databases in the environment
A user is affected if they run a vulnerable Metabase version (as specified in the affected ranges) with at least one SQLite database connection that lacks the limit_attached=0 mitigation in its connection configuration.
Generated from the published advisory. Verify against your own configuration.
Remediation Closing itWhat it takes to close this. Where a vendor fix exists we point at it; where none exists we say so plainly, and can build one. Effort estimates are scoped from the advisory, not from your codebase.
dbcve · scoped0.41.70.42.41.41.7
Upgrade to the patched Metabase version, or modify SQLite connection strings to include the url parameter '?limit_attached=0' to prevent attachment of additional databases.
Metabase 0.41.7, 0.42.4, 1.41.7, or 1.42.4 (depending on your current major version)
- Identify Metabase instances using SQLite as the database backend
- Upgrade Metabase to the fixed version corresponding to your current branch: for 0.41.x upgrade to 0.41.7, for 0.42.x upgrade to 0.42.4, for 1.41.x upgrade to 1.41.7, for 1.42.x upgrade to 1.42.4
- After upgrade, verify that SQLite connections work as expected
- Alternatively, if immediate upgrade is not possible, modify SQLite connection strings to include the url argument ?limit_attached=0 to prevent attaching other databases
- Test the connection after applying the mitigation parameter
Generated from the published advisory — verify against the referenced sources before acting.
- Consultation1.0 h
- Implementation2.0 h
- Testing2.0 h
- Review / QA1.0 h
An estimate, not a bill — we confirm scope with you before any work starts. Need it this week? Rush from $1,664.
Scan for this in your stack
Free · runs locallyCheck whether your project pulls in CVE-2022-24854 — or any other known-vulnerable package — straight from your lock files. Free and open source; it runs locally and uploads nothing.
References Go to the primary sourcePrimary sources — vendor advisories, patches and trackers. Where our summary and a reference disagree, the reference wins.
Primary sourcesPractitioner notes
ContributedPeer-ranked notes from engineers who’ve handled CVE-2022-24854 in production — separate from our analysis above.
The advisory tells you what broke. It rarely tells you what actually worked. If you’ve dealt with this one, that detail is what the next engineer is searching for.
- The version that genuinely resolved it — not the one the vendor claimed
- A config change or rule that shut the vector down
- A gotcha in the upgrade path that cost you an afternoon
No notes yet
Be the first to add a field note for this CVE — a mitigation you’ve verified, a version caveat, or a link to a working fix. Sign in above to contribute.
A place for practitioners to share what actually worked: a mitigation you’ve tested, a configuration change, a version- or environment-specific caveat, or a link to a verified patch. The most useful notes rise to the top as peers upvote them, so the signal stays high.
- Verified mitigations, workarounds, and config changes
- Version or environment caveats, and links to real fixes
- No weaponised exploit code, or anything meant to cause harm
- No spam, self-promotion, credentials, or personal data