Bug 1798852 (CVE-2020-1720) - CVE-2020-1720 PostgreSQL: ALTER ... DEPENDS ON EXTENSION is missing authorization checks
Summary: CVE-2020-1720 PostgreSQL: ALTER ... DEPENDS ON EXTENSION is missing authoriza...
Keywords:
Status: CLOSED ERRATA
Alias: CVE-2020-1720
Product: Security Response
Classification: Other
Component: vulnerability
Version: unspecified
Hardware: All
OS: Linux
low
low
Target Milestone: ---
Assignee: Red Hat Product Security
QA Contact:
URL:
Whiteboard:
Depends On: 1812457 1812459 1812460 1812461 1812462 1812464 1812465 1812466 1812467 1812468 1812469 1814512 1812456 1813839
Blocks: 1798853
TreeView+ depends on / blocked
 
Reported: 2020-02-06 07:01 UTC by Dhananjay Arunesh
Modified: 2020-03-26 16:32 UTC (History)
42 users (show)

Fixed In Version: PostgreSQL 12.2, PostgreSQL 11.7, PostgreSQL 10.12, PostgreSQL 9.6.17
Doc Type: If docs needed, set a value
Doc Text:
A flaw was found in PostgreSQL's "ALTER ... DEPENDS ON EXTENSION", where sub-commands did not perform authorization checks. An authenticated attacker could use this flaw in certain configurations to perform drop objects such as function, triggers, et al., leading to database corruption.
Clone Of:
Environment:
Last Closed: 2020-03-26 16:32:33 UTC


Attachments (Terms of Use)


Links
System ID Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2020:0980 None None None 2020-03-26 12:28:12 UTC

Description Dhananjay Arunesh 2020-02-06 07:01:47 UTC
The ALTER ... DEPENDS ON EXTENSION sub-commands do not perform authorization checks. If one of the following prerequisites holds, an unprivileged user can exploit this to drop any function, procedure, materialized view, index, or trigger. The attack is possible if an administrator has installed an extension that unprivileged users can CREATE. The attack is also possible if an extension owner issues DROP EXTENSION predictably or can be convinced to issue DROP EXTENSION.

Comment 2 Cedric Buissart 🐶 2020-03-11 11:52:02 UTC
PosgreSQL versions 9.5 and older are not affected by this issue beacuse they did not support the `ALTER THING .. DEPENDS ON EXTENSION` feature, which appeared in version 9.6.0.

Comment 3 Cedric Buissart 🐶 2020-03-11 11:53:37 UTC
Created mingw-postgresql tracking bugs for this issue:

Affects: fedora-all [bug 1812456]


Created postgresql tracking bugs for this issue:

Affects: fedora-all [bug 1812457]


Created postgresql:10/postgresql tracking bugs for this issue:

Affects: fedora-all [bug 1812460]


Created postgresql:11/postgresql tracking bugs for this issue:

Affects: fedora-all [bug 1812461]


Created postgresql:12/postgresql tracking bugs for this issue:

Affects: fedora-all [bug 1812462]


Created postgresql:9.6/postgresql tracking bugs for this issue:

Affects: fedora-all [bug 1812459]

Comment 4 Cedric Buissart 🐶 2020-03-11 11:56:07 UTC
Upstream fix (master branch) : https://github.com/postgres/postgres/commit/b048f558dd7c26a0c630a2cff29d3d8981eaf6b9

Comment 8 errata-xmlrpc 2020-03-26 12:28:04 UTC
This issue has been addressed in the following products:

  Red Hat Software Collections for Red Hat Enterprise Linux 7
  Red Hat Software Collections for Red Hat Enterprise Linux 7.5 EUS
  Red Hat Software Collections for Red Hat Enterprise Linux 7.6 EUS
  Red Hat Software Collections for Red Hat Enterprise Linux 7.7 EUS

Via RHSA-2020:0980 https://access.redhat.com/errata/RHSA-2020:0980

Comment 9 Product Security DevOps Team 2020-03-26 16:32:33 UTC
This bug is now closed. Further updates for individual products will be reflected on the CVE page(s):

https://access.redhat.com/security/cve/cve-2020-1720


Note You need to log in before you can comment on or make changes to this bug.