Skip to content
OpenAdvisories
Low · 3.1 CVE-2020-1720 EUVD-2020-12571GHSA-prcp-93mm-93fm

A flaw was found in PostgreSQL's "ALTER ... DEPENDS ON EXTENSION", where sub-commands did not perform authorization checks. An authenticate…

Published Mar 17, 2020 · Updated Aug 4, 2024 · Assigned by redhat

Description

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. This issue affects PostgreSQL versions before 12.2, before 11.7, before 10.12 and before 9.6.17.

Affected products

VendorProductAffectedFixed
Red Hat postgresql 12.2, 11.7, 10.12, 9.6.17 —

Fixed in Linux distributions

Distributions backport fixes, so the version that fixes this vulnerability differs per release — upgrade to at least the version shown. From the distributions' security trackers and advisories.

ReleasePackageFixed inAdvisory
Debian 10 postgresql-11 11.7-0+deb10u1 DSA-4623-1
Debian 9 postgresql-9.6 9.6.17-0+deb9u1 DSA-4622-1
Debian 8 postgresql-9.4 9.4.26-0+deb8u1 DLA-2105-1
ReleasePackageFixed inAdvisory
Ubuntu 18.04 LTS postgresql-10 10.12-0ubuntu0.18.04.1 USN-4282-1
ReleasePackageFixed inAdvisory
RHEL 8 pgaudit 1.4.0-4.module+el8.3.0+9042+664538f4 RHSA-2020:5620
RHEL 8 postgres-decoderbufs 0.10.0-2.module+el8.3.0+9042+664538f4 RHSA-2020:5620
RHEL 8 postgresql +10 9.6.20-1.module+el8.3.0+8938+7f0e88b6 RHSA-2020:5620, RHSA-2020:5619, RHSA-2020:3669
RHEL 8 postgresql-upgrade +1 10.14-1.module+el8.2.0+7801+be0fed80 RHSA-2020:5620, RHSA-2020:3669
RHEL 3 rh-postgresql10-postgresql +13 10.12-2.el7 RHSA-2020:0980
RHEL 3 rh-postgresql12-postgresql +13 12.4-1.el7 RHSA-2020:5112
RHEL 3 rh-postgresql96-postgresql +13 9.6.19-1.el7 RHSA-2020:4295
Show 4 more (older releases, extended support, other products)
ReleasePackageFixed inAdvisory
Red Hat Rhev Manager 4 rh-postgresql10-postgresql +13 10.12-2.el7 RHBA-2020:2396
Red Hat Rhev Manager 4 rhvm +20 4.3.10.3-0.2.el7 RHBA-2020:2396
RHEL 8.2 EUS pgaudit 1.4.0-4.module+el8.2.0+9043+1dbb5661 RHSA-2021:0163
RHEL 8.2 EUS postgres-decoderbufs 0.10.0-2.module+el8.2.0+9043+1dbb5661 RHSA-2021:0163
RHEL 8.2 EUS postgresql +10 9.6.20-1.module+el8.2.0+8939+9a3b4b64 RHSA-2021:0164, RHSA-2021:0163
RHEL 8.2 EUS postgresql-upgrade +1 12.5-1.module+el8.2.0+9043+1dbb5661 RHSA-2021:0163
RHEL 8.1 EUS postgresql +10 9.6.20-1.module+el8.1.0+9156+8ff1384f RHSA-2021:0167, RHSA-2021:0166
RHEL 8.1 EUS postgresql-upgrade +1 10.15-1.module+el8.1.0+9154+cd474635 RHSA-2021:0166
RHEL 8.0 E4S postgresql +10 9.6.20-1.module+el8.0.0+9157+356b8def RHSA-2020:5664, RHSA-2020:5661
RHEL 8.0 E4S postgresql-upgrade +1 10.15-1.module+el8.0.0+9155+4a85661a RHSA-2020:5664

AlmaLinux

Errata ↗
ReleasePackageFixed inAdvisory
AlmaLinux 8 postgres-decoderbufs 0.10.0-2.module_el8.6.0+2758+4f4474df ALSA-2020:5620

Rocky Linux

Errata ↗
ReleasePackageFixed inAdvisory
Rocky Linux 8 pgaudit 1.4.0-4.module+el8.4.0+545+ca56da2e RLSA-2020:5620
Rocky Linux 8 postgres-decoderbufs 0.10.0-2.module+el8.4.0+424+71d47d9a RLSA-2020:5620
ReleasePackageFixed inAdvisory
SLES 15 SP1 postgresql 12-8.11.3 SUSE-SU-2020:2149-1, SUSE-RU-2020:1280-1
SLES 15 SP1 postgresql10 10.12-8.9.1 SUSE-SU-2020:0752-1, SUSE-RU-2020:1280-1
SLES 15 SP1 postgresql12 +1 12.2-3.5.2 SUSE-SU-2020:2149-1, SUSE-RU-2020:1280-1
SLES 15 SP1 python-psycopg2 2.8.4-5.4.6 SUSE-RU-2020:1280-1
SLES 15 postgresql 12.0.1-8.14.1 SUSE-SU-2020:2149-1
SLES 15 postgresql10 10.12-4.19.1 SUSE-SU-2020:2149-1, SUSE-SU-2020:0589-1
SLES 12 SP5 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SLES 12 SP4 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SLES 12 SP3 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SLES 12 SP3 postgresql96 +1 9.6.17-3.33.1 SUSE-SU-2020:0586-1
Show 14 more (older releases, extended support, other products)
ReleasePackageFixed inAdvisory
SLES 12 SP2 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SLES 12 SP2 postgresql96 +1 9.6.17-3.33.1 SUSE-SU-2020:0586-1
SLES 12 SP1 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SLES 12 SP1 postgresql96 +1 9.6.17-3.33.1 SUSE-SU-2020:0586-1
SLES for SAP 15 postgresql 12.0.1-8.14.1 SUSE-SU-2020:2149-1
SLES for SAP 15 postgresql10 10.12-4.19.1 SUSE-SU-2020:2149-1, SUSE-SU-2020:0589-1
SLES for SAP 12 SP5 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SLES for SAP 12 SP4 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SLES for SAP 12 SP3 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SLES for SAP 12 SP3 postgresql96 +1 9.6.17-3.33.1 SUSE-SU-2020:0586-1
SLES for SAP 12 SP2 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SLES for SAP 12 SP2 postgresql96 +1 9.6.17-3.33.1 SUSE-SU-2020:0586-1
SLES for SAP 12 SP1 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SLES for SAP 12 SP1 postgresql96 +1 9.6.17-3.33.1 SUSE-SU-2020:0586-1
SLE HPC 15 postgresql 12.0.1-8.14.1 SUSE-SU-2020:2149-1
SLE HPC 15 postgresql10 10.12-4.19.1 SUSE-SU-2020:2149-1, SUSE-SU-2020:0589-1
SUSE OpenStack Cloud Crowbar 8 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SUSE OpenStack Cloud Crowbar 8 postgresql96 +1 9.6.17-3.33.1 SUSE-SU-2020:0586-1
SUSE OpenStack Cloud 8 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SUSE OpenStack Cloud 8 postgresql96 +1 9.6.17-3.33.1 SUSE-SU-2020:0586-1
SUSE OpenStack Cloud 7 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SUSE OpenStack Cloud 7 postgresql96 +1 9.6.17-3.33.1 SUSE-SU-2020:0586-1
SUSE HPE Helion OpenStack 8 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SUSE HPE Helion OpenStack 8 postgresql96 +1 9.6.17-3.33.1 SUSE-SU-2020:0586-1
SUSE Enterprise Storage 5 postgresql10 +1 10.12-1.18.1 SUSE-SU-2020:0715-1
SUSE Enterprise Storage 5 postgresql96 +1 9.6.17-3.33.1 SUSE-SU-2020:0586-1
ReleasePackageFixed inAdvisory
openSUSE Tumbleweed postgresql10 10.18-1.3 openSUSE-SU-2024:11184-1
openSUSE Tumbleweed postgresql11 11.13-1.3 openSUSE-SU-2024:11185-1
openSUSE Tumbleweed postgresql12 12.8-1.3 openSUSE-SU-2024:11186-1
openSUSE Leap 15.1 postgresql 12.0.1-lp151.6.9.1 openSUSE-SU-2020:1227-1
openSUSE Leap 15.1 postgresql10 10.12-lp151.2.9.1 openSUSE-SU-2020:1227-1, openSUSE-SU-2020:0331-1
openSUSE Leap 15.1 postgresql12 12.3-lp151.2.1 openSUSE-SU-2020:1227-1
openSUSE Leap 15.1 postgresql96 9.6.19-lp151.3.3.1 openSUSE-SU-2020:1227-1
ReleasePackageFixed inAdvisory
Alpine v3.20 postgresql14 +1 12.2-r0 —
Alpine v3.19 postgresql14 +1 12.2-r0 —
Alpine v3.18 postgresql12 +2 12.2-r0 —
Alpine v3.17 postgresql12 +2 12.2-r0 —
Alpine v3.16 postgresql12 +1 12.2-r0 —
Show 8 more (older releases, extended support, other products)
ReleasePackageFixed inAdvisory
Alpine v3.15 postgresql12 +1 12.2-r0 —
Alpine v3.14 postgresql 12.2-r0 —
Alpine v3.13 postgresql 12.2-r0 —
Alpine v3.12 postgresql 12.2-r0 —
Alpine v3.11 postgresql 12.2-r0 —
Alpine v3.10 postgresql 11.7-r0 —
Alpine v3.9 postgresql 11.7-r0 —
Alpine v3.8 postgresql 10.12-r0 —

Oracle Linux

ReleasePackageFixed inAdvisory
Oracle Linux 8 postgresql +12 10.14-1.module+el8.2.0+7785+0ea9f177 ELSA-2020-3669
Oracle Linux 7 rh-postgresql10-postgresql +13 10.15-1.el7 ELSA-2021-9290

Advisories 32

References