QID 356538

Date Published: 2023-11-08

QID 356538: Amazon Linux Security Advisory for postgresql15 : ALAS2023-2023-387

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. (
( CVE-2023-2455) 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. (
( CVE-2023-39418)



Note: The preceding description block is extracted directly from the security advisory. Using automation, we have attempted to clean and format it as much as possible without introducing additional issues.

Successful exploitation of this vulnerability could lead to a securitybreach or could affect integrity, availability, and confidentiality.

  • CVSS V3 rated as Medium - 5.4 severity.
  • CVSS V2 rated as Medium - 5.4 severity.
    • Solution
    Please refer to Amazon advisory: ALAS2023-2023-387 for affected packages and patching details, or update with your package manager.
    Vendor References

    CVEs related to QID 356538

    CVE-2023-39418 | CVE-2023-2455 |
    Software Advisories
    Advisory ID Software Component Link
    ALAS2023-2023-387 amazon linux 2023 URL Logo alas.aws.amazon.com/AL2023/ALAS-2023-387.html
    By selecting these links, you may be leaving CVEreport webspace. We have provided these links to other websites because they may have information that would be of interest to you. No inferences should be drawn on account of other sites being referenced, or not, from this page. There may be other websites that are more appropriate for your purpose. CVEreport does not necessarily endorse the views expressed, or concur with the facts presented on these sites. Further, CVEreport does not endorse any commercial products that may be mentioned on these sites. Please address comments about any linked pages to [email protected].