Bug 2207569 (CVE-2023-2455) - CVE-2023-2455 postgresql: row security policies disregard user ID changes after inlining.
Summary: CVE-2023-2455 postgresql: row security policies disregard user ID changes aft...
Keywords:
Status: NEW
Alias: CVE-2023-2455
Product: Security Response
Classification: Other
Component: vulnerability
Version: unspecified
Hardware: All
OS: Linux
medium
medium
Target Milestone: ---
Assignee: Nobody
QA Contact:
URL:
Whiteboard:
Depends On: 2207580 2207582 2207584 2207586 2207587 2207588 2207589 2207590 2207931 2207932 2207933 2207934 2207935 2207936 2228767 2207937 2207938 2208306 2212815 2214583 2214875 2224309
Blocks: 2203202
TreeView+ depends on / blocked
 
Reported: 2023-05-16 10:07 UTC by TEJ RATHI
Modified: 2023-08-08 08:38 UTC (History)
124 users (show)

Fixed In Version: PostgreSQL 15.3, PostgreSQL 14.8, PostgreSQL 13.11, PostgreSQL 12.15, PostgreSQL 11.20
Doc Type: If docs needed, set a value
Doc Text:
A flaw was found in PostgreSQL, which could permit incorrect policies being applied in certain cases where role-specific policies are used and a given query is planned under one role and executed under other roles. This scenario can happen under security definer functions, or when a common user and query is planned initially and then re-used across multiple SET ROLEs. Applying an incorrect policy may permit a user to complete otherwise forbidden reads and modifications. This only affects databases that have used CREATE POLICY to define a row security policy.
Clone Of:
Environment:
Last Closed:
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Product Errata RHSA-2023:3714 0 None None None 2023-06-21 14:38:59 UTC
Red Hat Product Errata RHSA-2023:4313 0 None None None 2023-07-27 13:32:49 UTC
Red Hat Product Errata RHSA-2023:4327 0 None None None 2023-07-31 09:19:41 UTC
Red Hat Product Errata RHSA-2023:4527 0 None None None 2023-08-08 08:37:52 UTC
Red Hat Product Errata RHSA-2023:4535 0 None None None 2023-08-08 08:38:01 UTC
Red Hat Product Errata RHSA-2023:4539 0 None None None 2023-08-08 08:38:20 UTC

Description TEJ RATHI 2023-05-16 10:07:59 UTC 
CVE-2023-2455: Row security policies disregard user ID changes after inlining.

Versions Affected: 11 - 15. This problem is quite old.

While CVE-2016-2193 fixed most interaction between row security and user ID changes, it missed a scenario involving function inlining. This leads to potentially incorrect policies being applied in cases where role-specific policies are used and a given query is planned under one role and then executed under other roles. This scenario can happen under security definer functions or when a common user and query is planned initially and then re-used across multiple SET ROLEs. Applying an incorrect policy may permit a user to complete otherwise-forbidden reads and modifications. This affects only databases that have used CREATE POLICY to define a row security policy.

https://www.postgresql.org/support/security/CVE-2023-2455/
Comment 1 TEJ RATHI 2023-05-16 10:17:57 UTC 
Created mingw-postgresql tracking bugs for this issue:

Affects: fedora-all [bug 2207582]


Created postgresql tracking bugs for this issue:

Affects: fedora-all [bug 2207580]


Created postgresql:10/postgresql tracking bugs for this issue:

Affects: fedora-all [bug 2207584]


Created postgresql:11/postgresql tracking bugs for this issue:

Affects: fedora-all [bug 2207586]


Created postgresql:12/postgresql tracking bugs for this issue:

Affects: fedora-all [bug 2207587]


Created postgresql:13/postgresql tracking bugs for this issue:

Affects: fedora-all [bug 2207588]


Created postgresql:14/postgresql tracking bugs for this issue:

Affects: fedora-all [bug 2207589]


Created postgresql:15/postgresql tracking bugs for this issue:

Affects: fedora-all [bug 2207590]
Comment 8 errata-xmlrpc 2023-06-21 14:38:50 UTC 
This issue has been addressed in the following products:

  Red Hat Enterprise Linux 9

Via RHSA-2023:3714 https://access.redhat.com/errata/RHSA-2023:3714
Comment 13 errata-xmlrpc 2023-07-27 13:32:43 UTC 
This issue has been addressed in the following products:

  Red Hat Software Collections for Red Hat Enterprise Linux 7

Via RHSA-2023:4313 https://access.redhat.com/errata/RHSA-2023:4313
Comment 14 errata-xmlrpc 2023-07-31 09:19:34 UTC 
This issue has been addressed in the following products:

  Red Hat Enterprise Linux 9

Via RHSA-2023:4327 https://access.redhat.com/errata/RHSA-2023:4327
Comment 15 errata-xmlrpc 2023-08-08 08:37:47 UTC 
This issue has been addressed in the following products:

  Red Hat Enterprise Linux 8

Via RHSA-2023:4527 https://access.redhat.com/errata/RHSA-2023:4527
Comment 16 errata-xmlrpc 2023-08-08 08:37:51 UTC 
This issue has been addressed in the following products:

  Red Hat Enterprise Linux 8

Via RHSA-2023:4535 https://access.redhat.com/errata/RHSA-2023:4535
Comment 17 errata-xmlrpc 2023-08-08 08:38:15 UTC 
This issue has been addressed in the following products:

  Red Hat Enterprise Linux 8

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