SQL injection in postgresql
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: 15 fixed, 1 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 found in PostgreSQL. There is an issue with incomplete efforts to operate safely when a privileged user is maintaining another user's objects. The Autovacuum, REINDEX, CREATE INDEX, REFRESH MATERIALIZED VIEW, CLUSTER, and pg_amcheck commands activated relevant protections too late or not at all during the process. This flaw allows an attacker with permission to create non-temporary objects in at least one schema to execute arbitrary SQL functions under a superuser identity.
Why it matters now
SSVC decision points
Not available: CISA has not published SSVC decision points for this record.
Affected products
| Vendor | Product | Affected versions | Fixed in | Status | Source |
|---|---|---|---|---|---|
| — | postgresql | Fixed in postgresql 14.3, postgresql 13.7, postgresql 12.11, postgresql 11.16, postgresql 10.21. | — | No fix listed | CNA |
- postgresql Vendor— Affected Fixed in postgresql 14.3, postgresql 13.7, postgresql 12.11, postgresql 11.16, postgresql 10.21. Fixed in — No fix listed CNA
CPE configurations NVD · 1
| CPE | Versions | Role | Vendor |
|---|---|---|---|
| cpe:2.3:a:postgresql:postgresql:*:*:*:*:*:*:*:* | 10.0 to before 10.21; 11.0 to before 11.16; 12.0 to before 12.11; 13.0 to before 13.7; 14.0 to before 14.3 | Vulnerable | PostgreSQL |
- cpe:2.3:a:postgresql:postgresql:*:*:*:*:*:*:*:* Versions 10.0 to before 10.21; 11.0 to before 11.16; 12.0 to before 12.11; 13.0 to before 13.7; 14.0 to before 14.3 Vulnerable ·PostgreSQL
Remediation
Red Hat 14 advisories
- RHSA-2022:5162 Released 2022-06-22 · Red Hat rating Importantpostgresql security update
- Red Hat Enterprise Linux Client (v. 7) postgresql-9.2.24-8.el7_9, postgresql-libs-9.2.24-8.el7_9
- Red Hat Enterprise Linux Client Optional (v. 7) postgresql-9.2.24-8.el7_9, postgresql-contrib-9.2.24-8.el7_9, postgresql-devel-9.2.24-8.el7_9 +8
- Red Hat Enterprise Linux ComputeNode Optional (v. 7) postgresql-9.2.24-8.el7_9, postgresql-contrib-9.2.24-8.el7_9, postgresql-devel-9.2.24-8.el7_9 +8
- Red Hat Enterprise Linux Server (v. 7) postgresql-9.2.24-8.el7_9, postgresql-9.2.24-8.el7_9.ppc, postgresql-contrib-9.2.24-8.el7_9 +10
- Red Hat Enterprise Linux Server Optional (v. 7) postgresql-static-9.2.24-8.el7_9, postgresql-static-9.2.24-8.el7_9.ppc, postgresql-upgrade-9.2.24-8.el7_9
- Red Hat Enterprise Linux Workstation (v. 7) postgresql-9.2.24-8.el7_9, postgresql-contrib-9.2.24-8.el7_9, postgresql-devel-9.2.24-8.el7_9 +6
- Red Hat Enterprise Linux Workstation Optional (v. 7) postgresql-docs-9.2.24-8.el7_9, postgresql-static-9.2.24-8.el7_9, postgresql-upgrade-9.2.24-8.el7_9
- RHSA-2022:4929 Released 2022-06-07 · Red Hat rating Importantrh-postgresql13-postgresql security update
- Red Hat Software Collections for RHEL Workstation(v. 7) rh-postgresql13-postgresql-13.7-1.el7, rh-postgresql13-postgresql-contrib-13.7-1.el7, rh-postgresql13-postgresql-contrib-syspaths-13.7-1.el7 +12
- Red Hat Software Collections for RHEL(v. 7) rh-postgresql13-postgresql-13.7-1.el7, rh-postgresql13-postgresql-contrib-13.7-1.el7, rh-postgresql13-postgresql-contrib-syspaths-13.7-1.el7 +12
- RHSA-2022:4913 Released 2022-06-06 · Red Hat rating Importantrh-postgresql10-postgresql security update
- Red Hat Software Collections for RHEL Workstation(v. 7) rh-postgresql10-postgresql-10.21-1.el7, rh-postgresql10-postgresql-contrib-10.21-1.el7, rh-postgresql10-postgresql-contrib-syspaths-10.21-1.el7 +11
- Red Hat Software Collections for RHEL(v. 7) rh-postgresql10-postgresql-10.21-1.el7, rh-postgresql10-postgresql-contrib-10.21-1.el7, rh-postgresql10-postgresql-contrib-syspaths-10.21-1.el7 +11
Show 11 more Red Hat advisories
- RHSA-2022:4915 Released 2022-06-06 · Red Hat rating Importantrh-postgresql12-postgresql security update
- Red Hat Software Collections for RHEL Workstation(v. 7) rh-postgresql12-postgresql-12.11-1.el7, rh-postgresql12-postgresql-contrib-12.11-1.el7, rh-postgresql12-postgresql-contrib-syspaths-12.11-1.el7 +11
- Red Hat Software Collections for RHEL(v. 7) rh-postgresql12-postgresql-12.11-1.el7, rh-postgresql12-postgresql-contrib-12.11-1.el7, rh-postgresql12-postgresql-contrib-syspaths-12.11-1.el7 +11
- RHSA-2022:4895 Released 2022-06-04 · Red Hat rating Importantpostgresql:10 security update
- Red Hat Enterprise Linux AppStream EUS (v. 8.2) postgresql-10.21-2.module+el8.2.0+15340+c4468608.aarch64::postgresql:10, postgresql-10.21-2.module+el8.2.0+15340+c4468608.ppc64le::postgresql:10, postgresql-10.21-2.module+el8.2.0+15340+c4468608.s390x::postgresql:10 +47
- RHSA-2022:4893 Released 2022-06-04 · Red Hat rating Importantpostgresql:12 security update
- Red Hat Enterprise Linux AppStream EUS (v. 8.2) pgaudit-1.4.0-4.module+el8.2.0+9043+1dbb5661.aarch64::postgresql:12, pgaudit-1.4.0-4.module+el8.2.0+9043+1dbb5661.ppc64le::postgresql:12, pgaudit-1.4.0-4.module+el8.2.0+9043+1dbb5661.s390x::postgresql:12 +47
- RHSA-2022:4894 Released 2022-06-03 · Red Hat rating Importantpostgresql:10 security update
- Red Hat Enterprise Linux AppStream E4S (v. 8.1) postgresql-10.21-2.module+el8.1.0+15339+34e1e10d.ppc64le::postgresql:10, postgresql-10.21-2.module+el8.1.0+15339+34e1e10d.src::postgresql:10, postgresql-10.21-2.module+el8.1.0+15339+34e1e10d.x86_64::postgresql:10 +24
- RHSA-2022:4857 Released 2022-06-01 · Red Hat rating Importantpostgresql:13 security update
- Red Hat Enterprise Linux AppStream EUS (v.8.4) pgaudit-1.5.0-1.module+el8.4.0+8873+b821c30a.aarch64::postgresql:13, pgaudit-1.5.0-1.module+el8.4.0+8873+b821c30a.ppc64le::postgresql:13, pgaudit-1.5.0-1.module+el8.4.0+8873+b821c30a.s390x::postgresql:13 +47
- RHSA-2022:4855 Released 2022-06-01 · Red Hat rating Importantpostgresql:13 security update
- Red Hat Enterprise Linux AppStream (v. 8) pg_repack-1.4.6-3.module+el8.5.0+11357+bcc62552.aarch64::postgresql:13, pg_repack-1.4.6-3.module+el8.5.0+11357+bcc62552.ppc64le::postgresql:13, pg_repack-1.4.6-3.module+el8.5.0+11357+bcc62552.s390x::postgresql:13 +47
- RHSA-2022:4856 Released 2022-06-01 · Red Hat rating Importantpostgresql:12 security update
- Red Hat Enterprise Linux AppStream EUS (v.8.4) pgaudit-1.4.0-6.module+el8.4.0+11288+c193d6d7.aarch64::postgresql:12, pgaudit-1.4.0-6.module+el8.4.0+11288+c193d6d7.ppc64le::postgresql:12, pgaudit-1.4.0-6.module+el8.4.0+11288+c193d6d7.s390x::postgresql:12 +47
- RHSA-2022:4854 Released 2022-06-01 · Red Hat rating Importantpostgresql:10 security update
- Red Hat Enterprise Linux AppStream EUS (v.8.4) postgresql-10.21-2.module+el8.4.0+15341+25c9f2fe.aarch64::postgresql:10, postgresql-10.21-2.module+el8.4.0+15341+25c9f2fe.ppc64le::postgresql:10, postgresql-10.21-2.module+el8.4.0+15341+25c9f2fe.s390x::postgresql:10 +47
- RHSA-2022:4807 Released 2022-05-31 · Red Hat rating Importantpostgresql:12 security update
- Red Hat Enterprise Linux AppStream (v. 8) pg_repack-1.4.6-3.module+el8.5.0+11354+78b3c9c5.aarch64::postgresql:12, pg_repack-1.4.6-3.module+el8.5.0+11354+78b3c9c5.ppc64le::postgresql:12, pg_repack-1.4.6-3.module+el8.5.0+11354+78b3c9c5.s390x::postgresql:12 +47
- RHSA-2022:4805 Released 2022-05-30 · Red Hat rating Importantpostgresql:10 security update
- Red Hat Enterprise Linux AppStream (v. 8) postgresql-10.21-2.module+el8.6.0+15342+53518fac.aarch64::postgresql:10, postgresql-10.21-2.module+el8.6.0+15342+53518fac.ppc64le::postgresql:10, postgresql-10.21-2.module+el8.6.0+15342+53518fac.s390x::postgresql:10 +47
- RHSA-2022:4771 Released 2022-05-30 · Red Hat rating Importantpostgresql security update
- Red Hat CodeReady Linux Builder (v. 9) postgresql-private-devel-13.7-1.el9_0, postgresql-server-devel-13.7-1.el9_0, postgresql-test-13.7-1.el9_0
- Red Hat Enterprise Linux AppStream (v. 9) postgresql-13.7-1.el9_0, postgresql-contrib-13.7-1.el9_0, postgresql-plperl-13.7-1.el9_0 +5
Vendor assessments
Red Hat
Red Hat rating: Important. Red Hat's page for this CVE →
| Product | Status | Plan or fix |
|---|---|---|
| Red Hat Enterprise Linux 6 | Affected | No fix planned: Out of support scope |
| Red Hat CodeReady Linux Builder (v. 9) | Fixed | RHSA-2022:4771 |
| Red Hat Enterprise Linux AppStream (v. 8) | Fixed | RHSA-2022:4805, RHSA-2022:4807, RHSA-2022:4855 |
| Red Hat Enterprise Linux AppStream (v. 9) | Fixed | RHSA-2022:4771 |
| Red Hat Enterprise Linux AppStream E4S (v. 8.1) | Fixed | RHSA-2022:4894 |
| Red Hat Enterprise Linux AppStream EUS (v. 8.2) | Fixed | RHSA-2022:4893, RHSA-2022:4895 |
| Red Hat Enterprise Linux AppStream EUS (v.8.4) | Fixed | RHSA-2022:4854, RHSA-2022:4856, RHSA-2022:4857 |
| Red Hat Enterprise Linux Client (v. 7) | Fixed | RHSA-2022:5162 |
| Red Hat Enterprise Linux Client Optional (v. 7) | Fixed | RHSA-2022:5162 |
| Red Hat Enterprise Linux ComputeNode Optional (v. 7) | Fixed | RHSA-2022:5162 |
| Red Hat Enterprise Linux Server (v. 7) | Fixed | RHSA-2022:5162 |
| Red Hat Enterprise Linux Server Optional (v. 7) | Fixed | RHSA-2022:5162 |
| Red Hat Enterprise Linux Workstation (v. 7) | Fixed | RHSA-2022:5162 |
| Red Hat Enterprise Linux Workstation Optional (v. 7) | Fixed | RHSA-2022:5162 |
| Red Hat Software Collections for RHEL Workstation(v. 7) | Fixed | RHSA-2022:4913, RHSA-2022:4915, RHSA-2022:4929 |
| Red Hat Software Collections for RHEL(v. 7) | Fixed | RHSA-2022:4913, RHSA-2022:4915, RHSA-2022:4929 |
Not affected: 7 products
- Red Hat Decision Manager 7
- Red Hat Enterprise Linux 8
- Red Hat Fuse 7
- Red Hat JBoss Enterprise Application Platform 6
- Red Hat JBoss Enterprise Application Platform 7
- Red Hat Process Automation 7
- Red Hat build of Quarkus
Timeline
- 2026-10-02 Threatist record created from CVE-2022-1552
- 2026-10-03 Alias added: GHSA-3f3c-74mp-823m
References
More Postgresql vulnerabilities
- 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-2018-00978 Improper input validation in postgresql CVSS 3.1HIGH 8.8
Sources
- CVE-2022-1552 · CVE Program
- CVE-2022-1552 · NVD
- FIRST EPSS
- GHSA-3f3c-74mp-823m · GitHub Advisory Database · CC BY 4.0
- CVE-2022-1552 · Red Hat security data · CC BY 4.0
This product uses the NVD API but is not endorsed or certified by the NVD. Sources and licences