CVE-2018-16850 : postgresql before versions 11.1, 10.6 is vulnerable to a to SQL injection in pg

postgresql before versions 11.1, 10.6 is vulnerable to a to SQL injection in pg_upgrade and pg_dump via CREATE TRIGGER ... REFERENCING. Using a purpose-crafted trigger definition, an attacker can cause arbitrary SQL statements to run, with superuser privileges.

Published 2018-11-13 15:29:00

Updated 2023-01-19 20:11:15

Source Red Hat, Inc.

View at NVD, CVE.org

Vulnerability category: Sql Injection

Products affected by CVE-2018-16850

Redhat » Enterprise Linux » Version: 7.0
cpe:2.3:o:redhat:enterprise_linux:7.0:*:*:*:*:*:*:*
Matching versions
Redhat » Enterprise Linux » Version: 7.4
cpe:2.3:o:redhat:enterprise_linux:7.4:*:*:*:*:*:*:*
Matching versions
Redhat » Enterprise Linux » Version: 7.5
cpe:2.3:o:redhat:enterprise_linux:7.5:*:*:*:*:*:*:*
Matching versions
Redhat » Enterprise Linux » Version: 7.6
cpe:2.3:o:redhat:enterprise_linux:7.6:*:*:*:*:*:*:*
Matching versions
Postgresql » Postgresql
Versions from including (>=) 10.0 and before (<) 10.6
cpe:2.3:a:postgresql:postgresql:*:*:*:*:*:*:*:*
Matching versions
Postgresql » Postgresql
Versions from including (>=) 11.0 and before (<) 11.1
cpe:2.3:a:postgresql:postgresql:*:*:*:*:*:*:*:*
Matching versions
Canonical » Ubuntu Linux » Version: 18.04 LTS Edition
cpe:2.3:o:canonical:ubuntu_linux:18.04:*:*:*:lts:*:*:*
Matching versions
Canonical » Ubuntu Linux » Version: 18.10
cpe:2.3:o:canonical:ubuntu_linux:18.10:*:*:*:*:*:*:*
Matching versions

Threat overview for CVE-2018-16850

Top countries where our scanners detected CVE-2018-16850

Top open port discovered on systems with this issue 80

IPs affected by CVE-2018-16850 330,248

Threat actors abusing to this issue? Yes

Find out if you^* are affected by CVE-2018-16850!

^*Directly or indirectly through your vendors, service providers and 3rd parties. Powered by attack surface intelligence from SecurityScorecard.

Exploit prediction scoring system (EPSS) score for CVE-2018-16850

EPSS FAQ

0.42%

Probability of exploitation activity in the next 30 days EPSS Score History

~ 59 %

Percentile, the proportion of vulnerabilities that are scored at or less

CVSS scores for CVE-2018-16850

Base Score	Base Severity	CVSS Vector	Exploitability Score	Impact Score	Score Source
7.5	HIGH	AV:N/AC:L/Au:N/C:P/I:P/A:P	10.0	6.4	NIST
Access Vector: Network Access Complexity: Low Authentication: None Confidentiality Impact: Partial Integrity Impact: Partial Availability Impact: Partial
8.0	HIGH	CVSS:3.0/AV:N/AC:L/PR:L/UI:R/S:U/C:H/I:H/A:H	2.1	5.9	Red Hat, Inc.
Attack Vector: Network Attack Complexity: Low Privileges Required: Low User Interaction: Required Scope: Unchanged Confidentiality: High Integrity: High Availability: High
9.8	CRITICAL	CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:H/I:H/A:H	3.9	5.9	NIST
Attack Vector: Network Attack Complexity: Low Privileges Required: None User Interaction: None Scope: Unchanged Confidentiality: High Integrity: High Availability: High

CWE ids for CVE-2018-16850

CWE-89 Improper Neutralization of Special Elements used in an SQL Command ('SQL Injection')

The product constructs all or part of an SQL command using externally-influenced input from an upstream component, but it does not neutralize or incorrectly neutralizes special elements that could modify the intended SQL command when it is sent to a downstream component. Without sufficient removal or quoting of SQL syntax in user-controllable inputs, the generated SQL query can cause those inputs to be interpreted as SQL instead of ordinary user data.
Assigned by:
- nvd@nist.gov (Primary)
- secalert@redhat.com (Secondary)

References for CVE-2018-16850

https://bugzilla.redhat.com/show_bug.cgi?id=CVE-2018-16850

1645937 – (CVE-2018-16850) CVE-2018-16850 postgresql: SQL injection in pg_upgrade and pg_dump, via CREATE TRIGGER ... REFERENCING
Issue Tracking;Patch;Third Party Advisory
https://usn.ubuntu.com/3818-1/

USN-3818-1: PostgreSQL vulnerability | Ubuntu security notices
Third Party Advisory
https://www.postgresql.org/about/news/1905/

PostgreSQL: PostgreSQL 11.1, 10.6, 9.6.11, 9.5.15, 9.4.20, and 9.3.25 Released!
Release Notes;Vendor Advisory
https://access.redhat.com/errata/RHSA-2018:3757

RHSA-2018:3757 - Security Advisory - Red Hat Customer Portal
Third Party Advisory
https://security.gentoo.org/glsa/201811-24

PostgreSQL: SQL injection (GLSA 201811-24) — Gentoo security
Mitigation;Third Party Advisory
http://www.securitytracker.com/id/1042144

PostgreSQL Transition Relation Name Misquoting Lets Remote Authenticated Users Gain Elevated Privileges - SecurityTracker
Third Party Advisory;VDB Entry
http://www.securityfocus.com/bid/105923

PostgreSQL CVE-2018-16850 Multiple SQL Injection Vulnerabilities
Third Party Advisory;VDB Entry