CVE-2020-1720 Missing authorization in postgresql

Low 3.1 Published Updated

An authenticated attacker can drop database objects like functions and triggers due to missing authorization checks in ALTER DEPENDS ON EXTENSION commands.

Exploited in the wild
Not known
Login needed
Any signed-in user
Attackable
Over the internet
Victim action needed
Not needed
Fix
Available

What is CVE-2020-1720?

CVE-2020-1720 is a low-severity missing authorization vulnerability in Postgresql Postgresql, published on 17 Mar 2020. Any signed-in user can exploit it over the network, with no action from the victim.

Official 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.

Weakness: CWE-862, CWE-285

Which versions are affected by CVE-2020-1720?

1 open source package ship an affected version, including postgresql. It affects 4 products.

PackageAffectedFixed in
postgresql BitnamiFrom 9.6.09.6.17, 10.12.0, 11.7.0, 12.2.0
Linux distribution packages (39)
ovirt-engine Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-backend Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-dbscripts Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-extensions-api-impl Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-extensions-api-impl-javadoc Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-health-check-bundler Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-restapi Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-setup Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-setup-base Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-setup-plugin-cinderlib Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-setup-plugin-ovirt-engine Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-setup-plugin-ovirt-engine-common Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-setup-plugin-vmconsole-proxy-helper Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-setup-plugin-websocket-proxy Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-tools Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-tools-backup Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-vmconsole-proxy-helper Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-webadmin-portal Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
ovirt-engine-websocket-proxy Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
python2-ovirt-engine-lib Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
rh-postgresql10-postgresql Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-contrib Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-contrib-syspaths Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-debuginfo Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-devel Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-docs Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-libs Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-plperl Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-plpython Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-pltcl Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-server Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-server-syspaths Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-static Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-syspaths Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rh-postgresql10-postgresql-test Red Hat:rhev_manager:4.3All versions0:10.12-2.el7
rhvm Red Hat:rhev_manager:4.3All versions0:4.3.10.3-0.2.el7
postgresql10 SUSE:Enterprise Storage 5All versions10.12-1.18.1
postgresql10-libs SUSE:Enterprise Storage 5All versions10.12-1.18.1
postgresql96 SUSE:Enterprise Storage 5All versions9.6.17-3.33.1

Products include Postgresql Postgresql, Redhat Decision Manager, Redhat Enterprise Linux, Redhat Software Collections.

How do I fix CVE-2020-1720?

Upgrade postgresql to a fixed version for your release line: 9.6.17, 10.12.0, 11.7.0 or 12.2.0.

Upgrade, and check permissions on every request on the server, not only in the interface. More about Missing authorization.

Is CVE-2020-1720 being exploited?

There is no known exploitation of CVE-2020-1720 in the wild and no public exploit code.

All Postgresql Postgresql vulnerabilities

Sources

Also known as ALPINE-CVE-2020-1720, BIT-postgresql-2020-1720, CLEANSTART-2026-QH42621, DLA-2105-1, DSA-4622-1, DSA-4623-1 and 11 more.

Is CVE-2020-1720 in your software?

Upload an SBOM and sbomify checks it against every vulnerability here, every day.

Check your SBOMs for free