Bug 1163985 - (CVE-2020-1720) VUL-1: CVE-2020-1720: postgresql94,postgresql96,postgresql,postgresql10: postgresql: ALTER ... DEPENDS ON EXTENSION is missing authorization checks
(CVE-2020-1720)
VUL-1: CVE-2020-1720: postgresql94,postgresql96,postgresql,postgresql10: post...
Status: RESOLVED FIXED
Classification: Novell Products
Product: SUSE Security Incidents
Classification: Novell Products
Component: Incidents
unspecified
Other Other
: P4 - Low : Normal
: ---
Assigned To: Security Team bot
Security Team bot
https://smash.suse.de/issue/253050/
CVSSv2:NVD:CVE-2020-1720:3.5:(AV:N/A...
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2020-02-17 17:42 UTC by Alexandros Toptsoglou
Modified: 2020-08-17 16:18 UTC (History)
3 users (show)

See Also:
Found By: Security Response Team
Services Priority:
Business Priority:
Blocker: ---
Marketing QA Status: ---
IT Deployment: ---


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Alexandros Toptsoglou 2020-02-17 17:42:59 UTC
CVE-2020-1720

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.

References:
https://bugzilla.redhat.com/show_bug.cgi?id=1798852
http://web.nvd.nist.gov/view/vuln/detail?vulnId=CVE-2020-1720
http://people.canonical.com/~ubuntu-security/cve/2020/CVE-2020-1720.html
http://www.debian.org/security/-1/dsa-4623
http://www.debian.org/security/-1/dsa-4622
Comment 1 Alexandros Toptsoglou 2020-02-17 17:54:11 UTC
Tracked as affected the following codestreams:

postgresql10: 

SLE11-SP1,SLE12,SLE15,SLE15-SP1, 

postgresql96:

SLE12

postgresql94:

SLE11-SP1,SLE12

postgresql: 

Leap 15.1 (inherited from SLE) and Factory (version 12)


FIXED versions:  12.2, 11.7, 10.12, 9.6.17, 9.5.21, and 9.4.26

Link to the advisory at [1] 

[1] https://www.postgresql.org/about/news/2011/
Comment 2 Reinhard Max 2020-02-18 14:41:28 UTC
According to upstream release announcements and release notes only versions from 9.6 onwards are affected, but 9.4 is not. But we might want to update 9.4 to the latest version anyway and notify customers that this will be the last update for 9.4 and they should upgrade to a newer version ASAP.

The "postgresql" package is also not affected as it is only an infrastructure package that does not contain any actual PosgtgreSQL code.
Comment 6 Swamp Workflow Management 2020-03-04 14:40:17 UTC
SUSE-SU-2020:0586-1: An update that fixes one vulnerability is now available.

Category: security (low)
Bug References: 1163985
CVE References: CVE-2020-1720
Sources used:
SUSE OpenStack Cloud Crowbar 8 (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
SUSE OpenStack Cloud 8 (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
SUSE OpenStack Cloud 7 (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
SUSE Linux Enterprise Server for SAP 12-SP3 (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
SUSE Linux Enterprise Server for SAP 12-SP2 (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
SUSE Linux Enterprise Server for SAP 12-SP1 (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
SUSE Linux Enterprise Server 12-SP3-LTSS (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
SUSE Linux Enterprise Server 12-SP3-BCL (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
SUSE Linux Enterprise Server 12-SP2-LTSS (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
SUSE Linux Enterprise Server 12-SP2-BCL (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
SUSE Linux Enterprise Server 12-SP1-LTSS (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
SUSE Enterprise Storage 5 (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1
HPE Helion Openstack 8 (src):    postgresql96-9.6.17-3.33.1, postgresql96-libs-9.6.17-3.33.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 7 Swamp Workflow Management 2020-03-05 14:14:31 UTC
SUSE-SU-2020:0589-1: An update that fixes one vulnerability is now available.

Category: security (low)
Bug References: 1163985
CVE References: CVE-2020-1720
Sources used:
SUSE Linux Enterprise Server for SAP 15 (src):    postgresql10-10.12-4.19.1
SUSE Linux Enterprise Server 15-LTSS (src):    postgresql10-10.12-4.19.1
SUSE Linux Enterprise Module for Server Applications 15 (src):    postgresql10-10.12-4.19.1
SUSE Linux Enterprise Module for Packagehub Subpackages 15 (src):    postgresql10-10.12-4.19.1
SUSE Linux Enterprise Module for Open Buildservice Development Tools 15 (src):    postgresql10-10.12-4.19.1
SUSE Linux Enterprise Module for Basesystem 15 (src):    postgresql10-10.12-4.19.1
SUSE Linux Enterprise High Performance Computing 15-LTSS (src):    postgresql10-10.12-4.19.1
SUSE Linux Enterprise High Performance Computing 15-ESPOS (src):    postgresql10-10.12-4.19.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 10 Swamp Workflow Management 2020-03-10 23:11:27 UTC
openSUSE-SU-2020:0331-1: An update that fixes one vulnerability is now available.

Category: security (low)
Bug References: 1163985
CVE References: CVE-2020-1720
Sources used:
openSUSE Leap 15.1 (src):    postgresql10-10.12-lp151.2.9.1
Comment 11 Swamp Workflow Management 2020-03-18 20:15:53 UTC
SUSE-SU-2020:0715-1: An update that fixes one vulnerability is now available.

Category: security (low)
Bug References: 1163985
CVE References: CVE-2020-1720
Sources used:
SUSE OpenStack Cloud Crowbar 8 (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE OpenStack Cloud 8 (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE OpenStack Cloud 7 (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Software Development Kit 12-SP5 (src):    postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Software Development Kit 12-SP4 (src):    postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Server for SAP 12-SP3 (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Server for SAP 12-SP2 (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Server for SAP 12-SP1 (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Server 12-SP5 (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Server 12-SP4 (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Server 12-SP3-LTSS (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Server 12-SP3-BCL (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Server 12-SP2-LTSS (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Server 12-SP2-BCL (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Server 12-SP1-LTSS (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Linux Enterprise Desktop 12-SP4 (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
SUSE Enterprise Storage 5 (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1
HPE Helion Openstack 8 (src):    postgresql10-10.12-1.18.1, postgresql10-libs-10.12-1.18.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 12 Swamp Workflow Management 2020-03-23 20:18:42 UTC
SUSE-SU-2020:0752-1: An update that fixes one vulnerability is now available.

Category: security (moderate)
Bug References: 1163985
CVE References: CVE-2020-1720
Sources used:
SUSE Linux Enterprise Module for Server Applications 15-SP1 (src):    postgresql10-10.12-8.9.1
SUSE Linux Enterprise Module for Open Buildservice Development Tools 15-SP1 (src):    postgresql10-10.12-8.9.1
SUSE Linux Enterprise Module for Basesystem 15-SP1 (src):    postgresql10-10.12-8.9.1

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 13 Swamp Workflow Management 2020-05-14 16:25:43 UTC
SUSE-RU-2020:1280-1: An update that solves two vulnerabilities and has three fixes is now available.

Category: recommended (moderate)
Bug References: 1138034,1151591,1153168,1163985,1167541
CVE References: CVE-2019-10164,CVE-2020-1720
Sources used:
SUSE Linux Enterprise Module for Server Applications 15-SP1 (src):    postgresql-12-8.11.3, postgresql10-10.12-8.13.10, postgresql10-10.12-8.13.9, postgresql12-12.2-3.5.2, postgresql12-libs-12.2-3.5.2
SUSE Linux Enterprise Module for Open Buildservice Development Tools 15-SP1 (src):    postgresql-12-8.11.3, postgresql10-10.12-8.13.10, postgresql10-10.12-8.13.9, postgresql12-12.2-3.5.2, postgresql12-libs-12.2-3.5.2, python-psycopg2-2.8.4-5.4.6
SUSE Linux Enterprise Module for Basesystem 15-SP1 (src):    postgresql-12-8.11.3, postgresql10-10.12-8.13.10, postgresql10-10.12-8.13.9, postgresql12-12.2-3.5.2, postgresql12-libs-12.2-3.5.2, python-psycopg2-2.8.4-5.4.6

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 15 Alexandros Toptsoglou 2020-07-02 12:15:11 UTC
Done
Comment 17 Swamp Workflow Management 2020-08-06 16:31:06 UTC
SUSE-SU-2020:2149-1: An update that solves one vulnerability and has two fixes is now available.

Category: security (moderate)
Bug References: 1148643,1163985,1171924
CVE References: CVE-2020-1720
JIRA References: 
Sources used:
SUSE Linux Enterprise Server for SAP 15 (src):    postgresql-12.0.1-8.14.1, postgresql10-10.13-4.22.4
SUSE Linux Enterprise Server 15-LTSS (src):    postgresql-12.0.1-8.14.1, postgresql10-10.13-4.22.4
SUSE Linux Enterprise Module for Server Applications 15-SP1 (src):    postgresql-12.0.1-8.14.1, postgresql12-12.3-3.8.1
SUSE Linux Enterprise Module for Packagehub Subpackages 15-SP1 (src):    postgresql-12.0.1-8.14.1
SUSE Linux Enterprise Module for Basesystem 15-SP1 (src):    postgresql-12.0.1-8.14.1, postgresql12-12.3-3.8.1
SUSE Linux Enterprise High Performance Computing 15-LTSS (src):    postgresql-12.0.1-8.14.1, postgresql10-10.13-4.22.4
SUSE Linux Enterprise High Performance Computing 15-ESPOS (src):    postgresql-12.0.1-8.14.1, postgresql10-10.13-4.22.4

NOTE: This line indicates an update has been released for the listed product(s). At times this might be only a partial fix. If you have questions please reach out to maintenance coordination.
Comment 18 OBSbugzilla Bot 2020-08-14 06:40:13 UTC
This is an autogenerated message for OBS integration:
This bug (1163985) was mentioned in
https://build.opensuse.org/request/show/826606 Factory / postgresql96
Comment 19 OBSbugzilla Bot 2020-08-14 08:10:36 UTC
This is an autogenerated message for OBS integration:
This bug (1163985) was mentioned in
https://build.opensuse.org/request/show/826617 15.1+15.2+Backports:SLE-15-SP1+Backports:SLE-15-SP2 / postgresql96
Comment 20 Swamp Workflow Management 2020-08-17 16:18:10 UTC
openSUSE-SU-2020:1227-1: An update that solves 7 vulnerabilities and has two fixes is now available.

Category: security (moderate)
Bug References: 1091610,1104199,1104202,1134689,1145092,1148643,1163985,1171924,1175194
CVE References: CVE-2018-10915,CVE-2018-10925,CVE-2018-1115,CVE-2019-10130,CVE-2019-10208,CVE-2020-14350,CVE-2020-1720
JIRA References: 
Sources used:
openSUSE Leap 15.1 (src):    postgresql-12.0.1-lp151.6.9.1, postgresql10-10.13-lp151.2.14.1, postgresql12-12.3-lp151.2.1, postgresql96-9.6.19-lp151.3.3.1