Bug 2228112 (CVE-2023-39418) - CVE-2023-39418 postgresql: MERGE fails to enforce UPDATE or SELECT row security policies
Summary: CVE-2023-39418 postgresql: MERGE fails to enforce UPDATE or SELECT row securi...
Keywords:
Status: NEW
Alias: CVE-2023-39418
Product: Security Response
Classification: Other
Component: vulnerability
Version: unspecified
Hardware: All
OS: Linux
low
low
Target Milestone: ---
Assignee: Nobody
QA Contact:
URL:
Whiteboard:
Depends On: 2228113 2228114
Blocks: 2228105
TreeView+ depends on / blocked
 
Reported: 2023-08-01 12:31 UTC by TEJ RATHI
Modified: 2024-01-09 16:22 UTC (History)
17 users (show)

Fixed In Version: postgresql 15.4
Doc Type: If docs needed, set a value
Doc Text:
A vulnerability was found in PostgreSQL with the use of the MERGE command, which fails to test new rows against row security policies defined for UPDATE and SELECT. If UPDATE and SELECT policies forbid some rows that INSERT policies do not forbid, a user could store such rows.
Clone Of:
Environment:
Last Closed:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHBA-2024:0031 0 None None None 2024-01-02 13:43:41 UTC
Red Hat Product Errata RHBA-2024:0063 0 None None None 2024-01-04 07:36:04 UTC
Red Hat Product Errata RHBA-2024:0099 0 None None None 2024-01-09 16:22:55 UTC
Red Hat Product Errata RHSA-2023:7785 0 None None None 2023-12-13 15:31:31 UTC
Red Hat Product Errata RHSA-2023:7883 0 None None None 2023-12-20 10:50:22 UTC
Red Hat Product Errata RHSA-2023:7884 0 None None None 2023-12-20 10:50:42 UTC
Red Hat Product Errata RHSA-2023:7885 0 None None None 2023-12-20 10:50:08 UTC

Description TEJ RATHI 2023-08-01 12:31:51 UTC 
PostgreSQL 15 introduced the MERGE command, which fails to test new rows against row security policies defined for UPDATE and SELECT. If UPDATE and SELECT policies forbid some row that INSERT policies do not forbid, a user could store such rows.  Subsequent consequences are application-dependent. This affects only databases that have used CREATE POLICY to define a row
security policy.

Vulnerable Version: 15
Comment 3 TEJ RATHI 2023-08-11 05:59:54 UTC 
This CVE is now public - https://www.postgresql.org/support/security/CVE-2023-39418
Comment 4 TEJ RATHI 2023-08-11 06:04:08 UTC 
Upstream commit:
https://git.postgresql.org/gitweb/?p=postgresql.git;a=commitdiff;h=cb2ae5741f2458a474ed3c31458d242e678ff229
Comment 6 errata-xmlrpc 2023-12-13 15:31:30 UTC 
This issue has been addressed in the following products:

  Red Hat Enterprise Linux 9

Via RHSA-2023:7785 https://access.redhat.com/errata/RHSA-2023:7785
Comment 7 errata-xmlrpc 2023-12-20 10:50:07 UTC 
This issue has been addressed in the following products:

  Red Hat Enterprise Linux 9.2 Extended Update Support

Via RHSA-2023:7885 https://access.redhat.com/errata/RHSA-2023:7885
Comment 8 errata-xmlrpc 2023-12-20 10:50:20 UTC 
This issue has been addressed in the following products:

  Red Hat Enterprise Linux 8.8 Extended Update Support

Via RHSA-2023:7883 https://access.redhat.com/errata/RHSA-2023:7883
Comment 9 errata-xmlrpc 2023-12-20 10:50:41 UTC 
This issue has been addressed in the following products:

  Red Hat Enterprise Linux 8

Via RHSA-2023:7884 https://access.redhat.com/errata/RHSA-2023:7884
Note You need to log in before you can comment on or make changes to this bug.