Read the docs
TI-2019-07528 Aliases CVE-2019-10208GHSA-7v5r-hqr9-r2x2

SQL injection in postgresql

Priority MEDIUM 42CWE-89Published · Updated

Key facts

Attack vector
Network
Privileges required
Low
User interaction
None
Attack complexity
Low
Impact type
SQL injection
Confidentiality · integrity · availability
High · High · High
Fix status
Partial Red Hat: 16 fixed, 4 without a fix

Attack profile from CVSS 3.1 · NVD. Fix status from CNA and Red Hat. Impact type from CWE-89.

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.

Why it matters now

EPSS 0.02188 82nd percentileScored 2026-11-07
Fix Partial Red Hat: 10 advisoriesRed Hat: 16 fixed, 4 without a fix

SSVC decision points

Not available: CISA has not published SSVC decision points for this record.

Affected products

VendorProductAffected versionsFixed inStatusSource
PostgreSQLpostgresqlall 11.x before 11.5; all 10.x before 10.10; all 9.6.x before 9.6.15; all 9.5.x before 9.5.19; all 9.4.x before 9.4.24—No fix listedCNA
  • postgresql VendorPostgreSQL Affected all 11.x before 11.5; all 10.x before 10.10; all 9.6.x before 9.6.15; all 9.5.x before 9.5.19; all 9.4.x before 9.4.24 Fixed in — No fix listed CNA

CPE configurations NVD · 1

CPEVersionsRoleVendor
cpe:2.3:a:postgresql:postgresql:*:*:*:*:*:*:*:*9.4.0 to before 9.4.24; 9.5.0 to before 9.5.19; 9.6.0 to before 9.6.15; 10.0 to before 10.10; 11.0 to before 11.5VulnerablePostgreSQL
  • cpe:2.3:a:postgresql:postgresql:*:*:*:*:*:*:*:* Versions 9.4.0 to before 9.4.24; 9.5.0 to before 9.5.19; 9.6.0 to before 9.6.15; 10.0 to before 10.10; 11.0 to before 11.5 Vulnerable ·PostgreSQL

Remediation

Red Hat 10 advisories

  • RHSA-2021:1512 Released 2021-05-06 · Red Hat rating Important
    postgresql security update
    • 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-contrib-9.2.24-6.el7_9, postgresql-devel-9.2.24-6.el7_9 +8
    • Red Hat Enterprise Linux ComputeNode Optional (v. 7) postgresql-9.2.24-6.el7_9, postgresql-contrib-9.2.24-6.el7_9, postgresql-devel-9.2.24-6.el7_9 +8
    • Red Hat Enterprise Linux Server (v. 7) postgresql-9.2.24-6.el7_9, postgresql-9.2.24-6.el7_9.ppc, postgresql-contrib-9.2.24-6.el7_9 +10
    • Red Hat Enterprise Linux Server Optional (v. 7) postgresql-static-9.2.24-6.el7_9, postgresql-static-9.2.24-6.el7_9.ppc, postgresql-upgrade-9.2.24-6.el7_9
    • Red Hat Enterprise Linux Workstation (v. 7) postgresql-9.2.24-6.el7_9, postgresql-contrib-9.2.24-6.el7_9, postgresql-devel-9.2.24-6.el7_9 +6
    • Red Hat Enterprise Linux Workstation Optional (v. 7) postgresql-docs-9.2.24-6.el7_9, postgresql-static-9.2.24-6.el7_9, postgresql-upgrade-9.2.24-6.el7_9
  • RHSA-2021:0167 Released 2021-01-18 · Red Hat rating Important
    postgresql:9.6 security update
    • Red Hat Enterprise Linux AppStream EUS (v. 8.1) postgresql-9.6.20-1.module+el8.1.0+9156+8ff1384f.aarch64::postgresql:9.6, postgresql-9.6.20-1.module+el8.1.0+9156+8ff1384f.ppc64le::postgresql:9.6, postgresql-9.6.20-1.module+el8.1.0+9156+8ff1384f.s390x::postgresql:9.6 +42
  • RHSA-2021:0166 Released 2021-01-18 · Red Hat rating Important
    postgresql:10 security update
    • Red Hat Enterprise Linux AppStream EUS (v. 8.1) postgresql-10.15-1.module+el8.1.0+9154+cd474635.aarch64::postgresql:10, postgresql-10.15-1.module+el8.1.0+9154+cd474635.ppc64le::postgresql:10, postgresql-10.15-1.module+el8.1.0+9154+cd474635.s390x::postgresql:10 +47
Show 7 more Red Hat advisories
  • RHSA-2021:0164 Released 2021-01-18 · Red Hat rating Important
    postgresql:9.6 security update
    • Red Hat Enterprise Linux AppStream EUS (v. 8.2) postgresql-9.6.20-1.module+el8.2.0+8939+9a3b4b64.aarch64::postgresql:9.6, postgresql-9.6.20-1.module+el8.2.0+8939+9a3b4b64.ppc64le::postgresql:9.6, postgresql-9.6.20-1.module+el8.2.0+8939+9a3b4b64.s390x::postgresql:9.6 +42
  • RHSA-2020:5664 Released 2020-12-22 · Red Hat rating Important
    postgresql:10 security update
    • Red Hat Enterprise Linux AppStream E4S (v. 8.0) postgresql-10.15-1.module+el8.0.0+9155+4a85661a.ppc64le::postgresql:10, postgresql-10.15-1.module+el8.0.0+9155+4a85661a.src::postgresql:10, postgresql-10.15-1.module+el8.0.0+9155+4a85661a.x86_64::postgresql:10 +24
  • RHSA-2020:5661 Released 2020-12-22 · Red Hat rating Important
    postgresql:9.6 security update
    • Red Hat Enterprise Linux AppStream E4S (v. 8.0) postgresql-9.6.20-1.module+el8.0.0+9157+356b8def.ppc64le::postgresql:9.6, postgresql-9.6.20-1.module+el8.0.0+9157+356b8def.src::postgresql:9.6, postgresql-9.6.20-1.module+el8.0.0+9157+356b8def.x86_64::postgresql:9.6 +20
  • RHSA-2020:5619 Released 2020-12-17 · Red Hat rating Important
    postgresql:9.6 security update
    • Red Hat Enterprise Linux AppStream (v. 8) postgresql-9.6.20-1.module+el8.3.0+8938+7f0e88b6.aarch64::postgresql:9.6, postgresql-9.6.20-1.module+el8.3.0+8938+7f0e88b6.ppc64le::postgresql:9.6, postgresql-9.6.20-1.module+el8.3.0+8938+7f0e88b6.s390x::postgresql:9.6 +42
  • RHSA-2020:4295 Released 2020-10-21 · Red Hat rating Moderate
    rh-postgresql96-postgresql security update
    • Red Hat Software Collections for Red Hat Enterprise Linux Server (v. 7) rh-postgresql96-postgresql-9.6.19-1.el7, rh-postgresql96-postgresql-contrib-9.6.19-1.el7, rh-postgresql96-postgresql-contrib-syspaths-9.6.19-1.el7 +11
    • Red Hat Software Collections for Red Hat Enterprise Linux Server EUS (v. 7.6) rh-postgresql96-postgresql-9.6.19-1.el7, rh-postgresql96-postgresql-contrib-9.6.19-1.el7, rh-postgresql96-postgresql-contrib-syspaths-9.6.19-1.el7 +11
    • Red Hat Software Collections for Red Hat Enterprise Linux Server EUS (v. 7.7) rh-postgresql96-postgresql-9.6.19-1.el7, rh-postgresql96-postgresql-contrib-9.6.19-1.el7, rh-postgresql96-postgresql-contrib-syspaths-9.6.19-1.el7 +11
    • Red Hat Software Collections for Red Hat Enterprise Linux Workstation (v. 7) rh-postgresql96-postgresql-9.6.19-1.el7, rh-postgresql96-postgresql-contrib-9.6.19-1.el7, rh-postgresql96-postgresql-contrib-syspaths-9.6.19-1.el7 +11
  • RHSA-2020:3669 Released 2020-09-08 · Red Hat rating Moderate
    postgresql:10 security and bug fix update
    • Red Hat Enterprise Linux AppStream (v. 8) postgresql-10.14-1.module+el8.2.0+7801+be0fed80.aarch64::postgresql:10, postgresql-10.14-1.module+el8.2.0+7801+be0fed80.ppc64le::postgresql:10, postgresql-10.14-1.module+el8.2.0+7801+be0fed80.s390x::postgresql:10 +47
  • RHSA-2020:0980 Released 2020-03-26 · Red Hat rating Moderate
    rh-postgresql10-postgresql security update
    • Red Hat Software Collections for Red Hat Enterprise Linux Server (v. 7) rh-postgresql10-postgresql-10.12-2.el7, rh-postgresql10-postgresql-contrib-10.12-2.el7, rh-postgresql10-postgresql-contrib-syspaths-10.12-2.el7 +11
    • Red Hat Software Collections for Red Hat Enterprise Linux Server EUS (v. 7.5) rh-postgresql10-postgresql-10.12-2.el7, rh-postgresql10-postgresql-contrib-10.12-2.el7, rh-postgresql10-postgresql-contrib-syspaths-10.12-2.el7 +11
    • Red Hat Software Collections for Red Hat Enterprise Linux Server EUS (v. 7.6) rh-postgresql10-postgresql-10.12-2.el7, rh-postgresql10-postgresql-contrib-10.12-2.el7, rh-postgresql10-postgresql-contrib-syspaths-10.12-2.el7 +11
    • Red Hat Software Collections for Red Hat Enterprise Linux Server EUS (v. 7.7) rh-postgresql10-postgresql-10.12-2.el7, rh-postgresql10-postgresql-contrib-10.12-2.el7, rh-postgresql10-postgresql-contrib-syspaths-10.12-2.el7 +11
    • Red Hat Software Collections for Red Hat Enterprise Linux Workstation (v. 7) rh-postgresql10-postgresql-10.12-2.el7, rh-postgresql10-postgresql-contrib-10.12-2.el7, rh-postgresql10-postgresql-contrib-syspaths-10.12-2.el7 +11

Vendor assessments

Red Hat

Red Hat rating: Moderate. Red Hat's page for this CVE →

ProductStatusPlan or fix
Red Hat Enterprise Linux 5AffectedNo fix planned: Out of support scope
Red Hat Enterprise Linux 6AffectedNo fix planned: Out of support scope
Red Hat Satellite 5AffectedNo fix planned: Out of support scope
Red Hat Virtualization 4AffectedNo fix planned: Will not fix
Red Hat Enterprise Linux AppStream (v. 8)Fixed RHSA-2020:3669, RHSA-2020:5619
Red Hat Enterprise Linux AppStream E4S (v. 8.0)Fixed RHSA-2020:5661, RHSA-2020:5664
Red Hat Enterprise Linux AppStream EUS (v. 8.1)Fixed RHSA-2021:0166, RHSA-2021:0167
Red Hat Enterprise Linux AppStream EUS (v. 8.2)Fixed RHSA-2021:0164
Red Hat Enterprise Linux Client (v. 7)Fixed RHSA-2021:1512
Red Hat Enterprise Linux Client Optional (v. 7)Fixed RHSA-2021:1512
Red Hat Enterprise Linux ComputeNode Optional (v. 7)Fixed RHSA-2021:1512
Red Hat Enterprise Linux Server (v. 7)Fixed RHSA-2021:1512
Red Hat Enterprise Linux Server Optional (v. 7)Fixed RHSA-2021:1512
Red Hat Enterprise Linux Workstation (v. 7)Fixed RHSA-2021:1512
Red Hat Enterprise Linux Workstation Optional (v. 7)Fixed RHSA-2021:1512
Red Hat Software Collections for Red Hat Enterprise Linux Server (v. 7)Fixed RHSA-2020:0980, RHSA-2020:4295
Red Hat Software Collections for Red Hat Enterprise Linux Server EUS (v. 7.5)Fixed RHSA-2020:0980
Red Hat Software Collections for Red Hat Enterprise Linux Server EUS (v. 7.6)Fixed RHSA-2020:0980, RHSA-2020:4295
Red Hat Software Collections for Red Hat Enterprise Linux Server EUS (v. 7.7)Fixed RHSA-2020:0980, RHSA-2020:4295
Red Hat Software Collections for Red Hat Enterprise Linux Workstation (v. 7)Fixed RHSA-2020:0980, RHSA-2020:4295
Not affected: 4 products
  • Red Hat Decision Manager 7
  • Red Hat Enterprise Linux 8
  • Red Hat Process Automation 7
  • Red Hat Storage 3

Timeline

  1. 2026-10-02 Threatist record created from CVE-2019-10208
  2. 2026-10-03 Alias added: GHSA-7v5r-hqr9-r2x2

References

Advisory 3

  • TI-2019-06651 In PostgreSQL 9.3 through 11.2, the "COPY TO/FROM PROGRAM" function allows superusers and… CVSS 3.0HIGH 7.2
  • TI-2017-05187 Improper authentication in postgresql CVSS 3.0CRITICAL 9.8
  • TI-2020-15711 SQL injection in postgresql CVSS 3.1HIGH 8.8
  • TI-2013-01675 Argument injection vulnerability in PostgreSQL 9.2.x before 9.2.4, 9.1.x before 9.1.9… CVSS 2.0MEDIUM 6.5
  • TI-2007-03176 The Database Link library (dblink) in PostgreSQL 8.1 implements functions via CREATE… CVSS 2.0HIGH 9.0
  • TI-2022-01423 SQL injection in postgresql CVSS 3.1HIGH 8.8
See all 202 →

Sources

This product uses the NVD API but is not endorsed or certified by the NVD. Sources and licences