Skip to content
Fencer Vulns
high 7.5

CVE-2019-10208 json

A flaw was discovered in postgresql versions 9.4.x before 9.4.24, 9.5.x before 9.5.19, 9.6.x before 9.6.15, 10.x before 10.10 and 11.x befo…

published 2019-10-29 7 y ago modified 2026-06-17 4 mo ago also EUVD-2019-2225

cvss
7.5
version 3.0, CNA
cisa kev
Not listed
not in CISA's catalog
epss
2.2%
EPSS 2.2% chance of exploitation in 30 days, percentile 82%
public exploits
0
none known

Summary

A flaw was discovered in postgresql versions 9.4.x before 9.4.24, 9.5.x before 9.5.19, 9.6.x before 9.6.15, 10.x before 10.10 and 11.x before 11.5 where arbitrary SQL statements can be executed given a suitable SECURITY DEFINER function. An attacker, with EXECUTE permission on the function, can execute arbitrary SQL as the owner of the function.

Patch / fix

  • postgresql postgresql 9.4.24, 9.5.19, 9.6.15, 10.10, 11.5
  • postgresql-10 Ubuntu 18.04 LTS 10.10-0ubuntu0.18.04.1
  • postgresql-9.5 Ubuntu 16.04 LTS 9.5.19-0ubuntu0.16.04.1

ubuntu advisories UBUNTU-CVE-2019-10208

Ubuntu security data © Canonical Ltd., from https://github.com/canonical/ubuntu-security-notices via OSV; changed: normalised to fixed package versions per release. CC BY-SA 4.0

  • postgresql RHEL 8 9.6.20-1.module+el8.3.0+8938+7f0e88b6
  • postgresql-test RHEL 8 9.6.20-1.module+el8.3.0+8938+7f0e88b6
  • postgresql-pltcl RHEL 8 9.6.20-1.module+el8.3.0+8938+7f0e88b6
  • postgresql-plperl RHEL 8 9.6.20-1.module+el8.3.0+8938+7f0e88b6
  • postgresql-server RHEL 8 9.6.20-1.module+el8.3.0+8938+7f0e88b6
  • postgresql-contrib RHEL 8 9.6.20-1.module+el8.3.0+8938+7f0e88b6
  • postgresql-plpython3 RHEL 8 9.6.20-1.module+el8.3.0+8938+7f0e88b6
  • postgresql-test-rpm-macros RHEL 8 9.6.20-1.module+el8.3.0+8938+7f0e88b6

red hat advisories RHSA-2021:0167RHSA-2021:0166RHSA-2021:0164RHSA-2020:5661RHSA-2020:5619RHSA-2020:5664

  • postgresql10 SLE Module for Server Applications 15 SP1, SLE Module for Basesystem 15 SP1 10.10-8.6.1
  • postgresql96 SLES for SAP 12 SP3, SLES for SAP 12 SP2, SLES for SAP 12 SP1 +11 more 9.6.15-3.29.1
  • postgresql96-libs SLES for SAP 12 SP3, SLES for SAP 12 SP2, SLES for SAP 12 SP1 +11 more 9.6.15-3.29.1
  • postgresql94 SLES for SAP 12 SP2, SLES for SAP 12 SP1, SLES 12 SP2-LTSS +4 more 9.4.24-21.25.1
  • postgresql10 SLE Module for Server Applications 15, SLE Module for Package Hub 15, SLE Module for Basesystem 15 10.10-4.16.1

suse advisories SUSE-SU-2019:2707-1SUSE-SU-2019:2159-1SUSE-SU-2019:2158-1SUSE-SU-2019:2228-1

  • postgresql10 openSUSE Tumbleweed 10.18-1.3
  • postgresql11 openSUSE Tumbleweed 11.13-1.3
  • postgresql10 openSUSE Leap 15.1 10.13-lp151.2.14.1
  • postgresql12 openSUSE Leap 15.1 12.3-lp151.2.1
  • postgresql openSUSE Leap 15.1 12.0.1-lp151.6.9.1
  • postgresql96 openSUSE Leap 15.1 9.6.19-lp151.3.3.1
  • postgresql10 openSUSE Leap 15.1, openSUSE Leap 15.0 10.10-lp151.2.6.1

opensuse advisories openSUSE-SU-2024:11184-1openSUSE-SU-2024:11185-1openSUSE-SU-2020:1227-1openSUSE-SU-2019:2062-1

  • postgresql Alpine 3.14, Alpine 3.13, Alpine 3.12 +3 more 11.5-r0
  • postgresql Alpine 3.8, Alpine 3.7 10.10-r0
  • postgresql14 Alpine 3.20, Alpine 3.19, Alpine 3.18 +3 more 11.5-r0
  • postgresql15 Alpine 3.20, Alpine 3.19, Alpine 3.18 +1 more 11.5-r0

alpine advisories ALPINE-CVE-2019-10208

Alpine secdb © Alpine Linux, from https://secdb.alpinelinux.org via OSV; changed: normalised to fixed package versions per release. CC BY-SA 4.0

  • postgresql Arch Linux 11.5-1
  • postgresql-libs Arch Linux 11.5-1

arch linux advisories AVG-1019

Vendor advisories

What the vendors themselves say about their products: affected, fixed or not affected, and what to do.

red hat product security vex CVE-2019-10208 updated cvss 7.5

postgresql: TYPE in pg_temp executes arbitrary SQL during SECURITY DEFINER execution

  • Red Hat Enterprise Linux 5 postgresql Red Hat Enterprise Linux 6 postgresql, postgresql-libs, postgresql-test, postgresql-pltcl, postgresql-plperl, postgresql-server, +2 more Red Hat Satellite 5 rh-postgresql95-postgresql Red Hat Virtualization 4 rh-postgresql10-postgresql, rh-postgresql95-postgresql, rh-postgresql10-postgresql-libs, rh-postgresql10-postgresql-test, rh-postgresql95-postgresql-libs, rh-postgresql95-postgresql-test, +13 more
    affected: workaround, no fix planned “Out of support scope”
  • Red Hat Enterprise Linux AppStream (v. 8) postgresql 10.14-1.module+el8.2.0+7801+be0fed80, postgresql 9.6.20-1.module+el8.3.0+8938+7f0e88b6, postgresql-test 10.14-1.module+el8.2.0+7801+be0fed80, postgresql-pltcl 10.14-1.module+el8.2.0+7801+be0fed80, postgresql-test 9.6.20-1.module+el8.3.0+8938+7f0e88b6, postgresql-plperl 10.14-1.module+el8.2.0+7801+be0fed80, +11 more
    fixed: vendor fix RHSA-2020:3669
  • Red Hat Enterprise Linux AppStream E4S (v. 8.0) postgresql 10.15-1.module+el8.0.0+9155+4a85661a, postgresql 9.6.20-1.module+el8.0.0+9157+356b8def, postgresql-test 10.15-1.module+el8.0.0+9155+4a85661a, postgresql-pltcl 10.15-1.module+el8.0.0+9155+4a85661a, postgresql-test 9.6.20-1.module+el8.0.0+9157+356b8def, postgresql-plperl 10.15-1.module+el8.0.0+9155+4a85661a, +11 more
    fixed: vendor fix RHSA-2020:5664
  • Red Hat Enterprise Linux AppStream EUS (v. 8.1) postgresql 10.15-1.module+el8.1.0+9154+cd474635, postgresql 9.6.20-1.module+el8.1.0+9156+8ff1384f, postgresql-test 10.15-1.module+el8.1.0+9154+cd474635, postgresql-pltcl 10.15-1.module+el8.1.0+9154+cd474635, postgresql-test 9.6.20-1.module+el8.1.0+9156+8ff1384f, postgresql-plperl 10.15-1.module+el8.1.0+9154+cd474635, +11 more
    fixed: vendor fix RHSA-2021:0166
  • Red Hat Enterprise Linux AppStream EUS (v. 8.2) postgresql 9.6.20-1.module+el8.2.0+8939+9a3b4b64, postgresql-test 9.6.20-1.module+el8.2.0+8939+9a3b4b64, postgresql-pltcl 9.6.20-1.module+el8.2.0+8939+9a3b4b64, postgresql-plperl 9.6.20-1.module+el8.2.0+8939+9a3b4b64, postgresql-server 9.6.20-1.module+el8.2.0+8939+9a3b4b64, postgresql-contrib 9.6.20-1.module+el8.2.0+8939+9a3b4b64, +2 more
    fixed: vendor fix RHSA-2021:0164
  • Red Hat Enterprise Linux Client (v. 7) postgresql 9.2.24-6.el7_9, postgresql-libs 9.2.24-6.el7_9 Red Hat Enterprise Linux Client Optional (v. 7) postgresql 9.2.24-6.el7_9, postgresql-test 9.2.24-6.el7_9, postgresql-pltcl 9.2.24-6.el7_9, postgresql-plperl 9.2.24-6.el7_9, postgresql-server 9.2.24-6.el7_9, postgresql-contrib 9.2.24-6.el7_9, +2 more Red Hat Enterprise Linux ComputeNode Optional (v. 7) postgresql 9.2.24-6.el7_9, postgresql-test 9.2.24-6.el7_9, postgresql-pltcl 9.2.24-6.el7_9, postgresql-plperl 9.2.24-6.el7_9, postgresql-server 9.2.24-6.el7_9, postgresql-contrib 9.2.24-6.el7_9, +2 more Red Hat Enterprise Linux Server (v. 7) postgresql 9.2.24-6.el7_9, postgresql-libs 9.2.24-6.el7_9, postgresql-test 9.2.24-6.el7_9, postgresql-pltcl 9.2.24-6.el7_9, postgresql-plperl 9.2.24-6.el7_9, postgresql-server 9.2.24-6.el7_9, +2 more Red Hat Enterprise Linux Server Optional (v. 7) postgresql-upgrade 9.2.24-6.el7_9 Red Hat Enterprise Linux Workstation (v. 7) postgresql 9.2.24-6.el7_9, postgresql-libs 9.2.24-6.el7_9, postgresql-test 9.2.24-6.el7_9, postgresql-pltcl 9.2.24-6.el7_9, postgresql-plperl 9.2.24-6.el7_9, postgresql-server 9.2.24-6.el7_9, +2 more
    +1 more products
    Red Hat Enterprise Linux Workstation Optional (v. 7) postgresql-upgrade 9.2.24-6.el7_9
    fixed: vendor fix RHSA-2021:1512
  • Red Hat Software Collections for Red Hat Enterprise Linux Server (v. 7) rh-postgresql10-postgresql 10.12-2.el7, rh-postgresql96-postgresql 9.6.19-1.el7, rh-postgresql10-postgresql-libs 10.12-2.el7, rh-postgresql10-postgresql-test 10.12-2.el7, rh-postgresql10-postgresql-pltcl 10.12-2.el7, rh-postgresql96-postgresql-libs 9.6.19-1.el7, +16 more Red Hat Software Collections for Red Hat Enterprise Linux Server EUS (v. 7.5) rh-postgresql10-postgresql 10.12-2.el7, rh-postgresql10-postgresql-libs 10.12-2.el7, rh-postgresql10-postgresql-test 10.12-2.el7, rh-postgresql10-postgresql-pltcl 10.12-2.el7, rh-postgresql10-postgresql-plperl 10.12-2.el7, rh-postgresql10-postgresql-server 10.12-2.el7, +5 more Red Hat Software Collections for Red Hat Enterprise Linux Server EUS (v. 7.6) rh-postgresql10-postgresql 10.12-2.el7, rh-postgresql96-postgresql 9.6.19-1.el7, rh-postgresql10-postgresql-libs 10.12-2.el7, rh-postgresql10-postgresql-test 10.12-2.el7, rh-postgresql10-postgresql-pltcl 10.12-2.el7, rh-postgresql96-postgresql-libs 9.6.19-1.el7, +16 more Red Hat Software Collections for Red Hat Enterprise Linux Server EUS (v. 7.7) rh-postgresql10-postgresql 10.12-2.el7, rh-postgresql96-postgresql 9.6.19-1.el7, rh-postgresql10-postgresql-libs 10.12-2.el7, rh-postgresql10-postgresql-test 10.12-2.el7, rh-postgresql10-postgresql-pltcl 10.12-2.el7, rh-postgresql96-postgresql-libs 9.6.19-1.el7, +16 more Red Hat Software Collections for Red Hat Enterprise Linux Workstation (v. 7) rh-postgresql10-postgresql 10.12-2.el7, rh-postgresql96-postgresql 9.6.19-1.el7, rh-postgresql10-postgresql-libs 10.12-2.el7, rh-postgresql10-postgresql-test 10.12-2.el7, rh-postgresql10-postgresql-pltcl 10.12-2.el7, rh-postgresql96-postgresql-libs 9.6.19-1.el7, +16 more
    fixed: vendor fix RHSA-2020:0980
  • Red Hat Decision Manager 7 postgresql Red Hat Enterprise Linux 8 libpq Red Hat Process Automation 7 postgresql Red Hat Storage 3 rhevm-dependencies
    not affected: vulnerable code not present

Red Hat CSAF VEX © Red Hat, Inc., from https://security.access.redhat.com/data/csaf/v2/vex/; changed: reduced to product statuses and remediations. CC BY 4.0 · csaf

Exploit prediction

2.19% chance of exploitation in the next 30 days, higher than 82% of all scored CVEs (FIRST EPSS, 2026-11-08).

CVSS scores

assigned by version score vector
CNA 3.0 7.5 CVSS:3.0/AV:N/AC:H/PR:L/UI:N/S:U/C:H/I:H/A:H
NVD 3.1 8.8 CVSS:3.1/AV:N/AC:L/PR:L/UI:N/S:U/C:H/I:H/A:H
NVD 2.0 6.5 AV:N/AC:L/Au:S/C:P/I:P/A:P

Affected products

  • PostgreSQL postgresql

Classification

Weakness
  • CWE-89 Improper Neutralization of Special Elements used in an SQL Command
Technology feeds

References

Sources

Fencer Vulns keeps one entry per vulnerability: the CVE id wins, then GHSA, and records that alias each other are merged, except that two CVEs always keep separate entries. The same data is available as JSON.