Improper Input Validation Affecting postgresql-upgrade package, versions <0:9.2.24-8.amzn2.0.2


Severity

Recommended
high

Based on Amazon Linux security rating.

Threat Intelligence

EPSS
0.09% (42nd percentile)

Do your applications use this vulnerable package?

In a few clicks we can analyze your entire application and see what components are vulnerable in your application, and suggest you quick fixes.

Test your applications

Snyk Learn

Learn about Improper Input Validation vulnerabilities in an interactive lesson.

Start learning
  • Snyk IDSNYK-AMZN2-POSTGRESQLUPGRADE-9299230
  • published7 Mar 2025
  • disclosed9 Jun 2023

Introduced: 9 Jun 2023

CVE-2023-2455  (opens in a new tab)
CWE-20  (opens in a new tab)

How to fix?

Upgrade Amazon-Linux:2 postgresql-upgrade to version 0:9.2.24-8.amzn2.0.2 or higher.
This issue was patched in ALAS2-2024-2462.

NVD Description

Note: Versions mentioned in the description apply only to the upstream postgresql-upgrade package and not the postgresql-upgrade package as distributed by Amazon-Linux. See How to fix? for Amazon-Linux:2 relevant fixed versions and status.

Row security policies disregard user ID changes after inlining; PostgreSQL could permit incorrect policies to be applied in certain 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.

CVSS Base Scores

version 3.1