Database object deletion via unchecked extension dependencies
Published Mar 17, 2020 · Updated Aug 4, 2024
Improper authorization in PostgreSQL 9.6 through 12 allows remote authenticated users to arrange deletion of database objects. ALTER ... DEPENDS ON EXTENSION records extension dependencies for functions, procedures, materialized views, indexes, and triggers without verifying that the caller owns the object. Exploitation requires CREATE access plus an installed extension and succeeds when that extension is later dropped, causing the marked objects to be deleted.
Summary
What happened
Improper authorization in PostgreSQL 9.6 through 12 allows remote authenticated users to arrange deletion of database objects. ALTER ... DEPENDS ON EXTENSION records extension dependencies for functions, procedures, materialized views, indexes, and triggers without verifying that the caller owns the object. Exploitation requires CREATE access plus an installed extension and succeeds when that extension is later dropped, causing the marked objects to be deleted.
The record
- CVE
- CVE-2020-1720
- Published
- Mar 17, 2020
- Updated
- Aug 4, 2024
- Vendor
- Red Hat
- Product
- PostgreSQL
- Classifications
- CWE-285, CWE-862, T1485
- Attack vector
- network
- Privileges
- authenticated
Timeline
How it unfolded
- Mar 17, 2020CVE publishedPublication date reported by the CVE source.
- Aug 4, 2024Record updatedLatest update available in the CVE record.
Exploitability
Present is not the same as exploitable
Compare your product and version with the public record. A matching version still requires validation against your environment.
Is a vulnerable build present?
Compare these published version ranges with your installed build and any vendor patches.
- Affected versionversion=10.12
- Affected versionversion=11.7
- Affected versionversion=12.2
- Affected versionversion=9.6.17
What conditions does exploitation require?
What is affected?
Published CVSS scores
CVSS describes severity. EPSS estimates exploitation probability.
Attacks
What attackers are doing with it
Daily unique IPs observed by Shadowserver honeypots for known exploited vulnerabilities (KEVs). Missing observations do not establish an absence of attacks.
Weakness, pattern, technique
Public exploit references
No public exploit references are available in this record.
Labels summarize the accepted research assessment. They do not indicate a test against your environment.
Technologies
Your stack
See the directory against your own environment.
Your stack
Check the software in your environment
Book a demo to see how Hinoki identifies affected software and validates exploitability in your environment.
Book a demo