Red Hat Security Advisory: postgresql security update
🔗 CVE IDs covered (3)
📋 Description
CVE-2024-10976 — postgresql: PostgreSQL row security below e.g. subqueries disregards user ID changes CVE-2024-10978 — postgresql: PostgreSQL SET ROLE, SET SESSION AUTHORIZATION reset to wrong user ID CVE-2024-10979 — postgresql: PostgreSQL PL/Perl environment variable changes execute arbitrary code
🎯 Affected products164
- Red Hat CodeReady Linux Builder (v. 9)
- Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-0:13.18-1.el9_5.aarch64 as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-0:13.18-1.el9_5.ppc64le as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-0:13.18-1.el9_5.s390x as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-0:13.18-1.el9_5.src as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-0:13.18-1.el9_5.x86_64 as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-contrib-0:13.18-1.el9_5.aarch64 as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-contrib-0:13.18-1.el9_5.ppc64le as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-contrib-0:13.18-1.el9_5.s390x as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-contrib-0:13.18-1.el9_5.x86_64 as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-contrib-debuginfo-0:13.18-1.el9_5.aarch64 as a component of Red Hat CodeReady Linux Builder (v. 9)
- postgresql-contrib-debuginfo-0:13.18-1.el9_5.aarch64 as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-contrib-debuginfo-0:13.18-1.el9_5.ppc64le as a component of Red Hat CodeReady Linux Builder (v. 9)
- postgresql-contrib-debuginfo-0:13.18-1.el9_5.ppc64le as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-contrib-debuginfo-0:13.18-1.el9_5.s390x as a component of Red Hat CodeReady Linux Builder (v. 9)
- postgresql-contrib-debuginfo-0:13.18-1.el9_5.s390x as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-contrib-debuginfo-0:13.18-1.el9_5.x86_64 as a component of Red Hat CodeReady Linux Builder (v. 9)
- postgresql-contrib-debuginfo-0:13.18-1.el9_5.x86_64 as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-debuginfo-0:13.18-1.el9_5.aarch64 as a component of Red Hat CodeReady Linux Builder (v. 9)
- postgresql-debuginfo-0:13.18-1.el9_5.aarch64 as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-debuginfo-0:13.18-1.el9_5.ppc64le as a component of Red Hat CodeReady Linux Builder (v. 9)
- postgresql-debuginfo-0:13.18-1.el9_5.ppc64le as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-debuginfo-0:13.18-1.el9_5.s390x as a component of Red Hat CodeReady Linux Builder (v. 9)
- postgresql-debuginfo-0:13.18-1.el9_5.s390x as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-debuginfo-0:13.18-1.el9_5.x86_64 as a component of Red Hat CodeReady Linux Builder (v. 9)
- postgresql-debuginfo-0:13.18-1.el9_5.x86_64 as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-debugsource-0:13.18-1.el9_5.aarch64 as a component of Red Hat CodeReady Linux Builder (v. 9)
- postgresql-debugsource-0:13.18-1.el9_5.aarch64 as a component of Red Hat Enterprise Linux AppStream (v. 9)
- postgresql-debugsource-0:13.18-1.el9_5.ppc64le as a component of Red Hat CodeReady Linux Builder (v. 9)
- +134 more not shown
✅ Remediation
For details on how to apply this update, which includes the changes described in this advisory, refer to: https://access.redhat.com/articles/11258 Workaround: Mitigation for this issue is either not available or the currently available options don't meet the Red Hat Product Security criteria comprising ease of use and deployment, applicability to widespread installation base or stability. Workaround: Currently the following options exist to help mitigate the impact of this vulnerability: 1) Restrict Permissions: the creation of PL/Python and PL/Perl functions should be limited to trusted users only. 2) Environment Variable Sanitization: ensure that environment variables are properly sanitized and any modifications are restricted. 3) Upgrade PostgreSQL: if a fix is released by the PostgreSQL Global Development Group, update to the latest version. 4) Audit Database Functions: perform regular audits on user-created functions to detect and prevent potential exploitation.
🔗 References (6)
- selfhttps://access.redhat.com/errata/RHSA-2024:10791
- externalhttps://access.redhat.com/security/updates/classification/#important
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=2326251
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=2326253
- externalhttps://bugzilla.redhat.com/show_bug.cgi?id=2326263
- selfhttps://security.access.redhat.com/data/csaf/v2/advisories/2024/rhsa-2024_10791.json