ALASPOSTGRESQL11-2023-001

Related Vulnerabilities: CVE-2023-2454   CVE-2023-2455  

This enabled an attacker having database-level CREATE privilege to execute arbitrary code as the bootstrap superuser. Database owners have that right by default, and explicit grants may extend it to other users. (CVE-2023-2454) 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)

ALASPOSTGRESQL11-2023-001


Amazon Linux 2 Security Advisory: ALASPOSTGRESQL11-2023-001
Advisory Release Date: 2023-08-07 05:59 Pacific
Advisory Updated Date: 2023-09-25 22:08 Pacific
Severity: Important

Issue Overview:

This enabled an attacker having database-level CREATE privilege to execute arbitrary code as the bootstrap superuser. Database owners have that right by default, and explicit grants may extend it to other users. (CVE-2023-2454)

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)


Affected Packages:

postgresql


Issue Correction:
Run yum update postgresql to update your system.

New Packages:
aarch64:
    postgresql-11.20-1.amzn2.0.1.aarch64
    postgresql-server-11.20-1.amzn2.0.1.aarch64
    postgresql-docs-11.20-1.amzn2.0.1.aarch64
    postgresql-contrib-11.20-1.amzn2.0.1.aarch64
    postgresql-server-devel-11.20-1.amzn2.0.1.aarch64
    postgresql-static-11.20-1.amzn2.0.1.aarch64
    postgresql-upgrade-11.20-1.amzn2.0.1.aarch64
    postgresql-upgrade-devel-11.20-1.amzn2.0.1.aarch64
    postgresql-plperl-11.20-1.amzn2.0.1.aarch64
    postgresql-plpython2-11.20-1.amzn2.0.1.aarch64
    postgresql-plpython3-11.20-1.amzn2.0.1.aarch64
    postgresql-pltcl-11.20-1.amzn2.0.1.aarch64
    postgresql-test-11.20-1.amzn2.0.1.aarch64
    postgresql-debuginfo-11.20-1.amzn2.0.1.aarch64

i686:
    postgresql-11.20-1.amzn2.0.1.i686
    postgresql-server-11.20-1.amzn2.0.1.i686
    postgresql-docs-11.20-1.amzn2.0.1.i686
    postgresql-contrib-11.20-1.amzn2.0.1.i686
    postgresql-server-devel-11.20-1.amzn2.0.1.i686
    postgresql-static-11.20-1.amzn2.0.1.i686
    postgresql-upgrade-11.20-1.amzn2.0.1.i686
    postgresql-upgrade-devel-11.20-1.amzn2.0.1.i686
    postgresql-plperl-11.20-1.amzn2.0.1.i686
    postgresql-plpython2-11.20-1.amzn2.0.1.i686
    postgresql-plpython3-11.20-1.amzn2.0.1.i686
    postgresql-pltcl-11.20-1.amzn2.0.1.i686
    postgresql-test-11.20-1.amzn2.0.1.i686
    postgresql-debuginfo-11.20-1.amzn2.0.1.i686

noarch:
    postgresql-test-rpm-macros-11.20-1.amzn2.0.1.noarch

src:
    postgresql-11.20-1.amzn2.0.1.src

x86_64:
    postgresql-11.20-1.amzn2.0.1.x86_64
    postgresql-server-11.20-1.amzn2.0.1.x86_64
    postgresql-docs-11.20-1.amzn2.0.1.x86_64
    postgresql-contrib-11.20-1.amzn2.0.1.x86_64
    postgresql-server-devel-11.20-1.amzn2.0.1.x86_64
    postgresql-static-11.20-1.amzn2.0.1.x86_64
    postgresql-upgrade-11.20-1.amzn2.0.1.x86_64
    postgresql-upgrade-devel-11.20-1.amzn2.0.1.x86_64
    postgresql-plperl-11.20-1.amzn2.0.1.x86_64
    postgresql-plpython2-11.20-1.amzn2.0.1.x86_64
    postgresql-plpython3-11.20-1.amzn2.0.1.x86_64
    postgresql-pltcl-11.20-1.amzn2.0.1.x86_64
    postgresql-test-11.20-1.amzn2.0.1.x86_64
    postgresql-debuginfo-11.20-1.amzn2.0.1.x86_64