Red Hat: CVE-2023-2455: postgresql: row security policies disregard user ID changes after inlining. (Multiple Advisories)
Description
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.
Solution(s)
- redhat-upgrade-pg_repack
- redhat-upgrade-pg_repack-debuginfo
- redhat-upgrade-pg_repack-debugsource
- redhat-upgrade-pgaudit
- redhat-upgrade-pgaudit-debuginfo
- redhat-upgrade-pgaudit-debugsource
- redhat-upgrade-postgres-decoderbufs
- redhat-upgrade-postgres-decoderbufs-debuginfo
- redhat-upgrade-postgres-decoderbufs-debugsource
- redhat-upgrade-postgresql
- redhat-upgrade-postgresql-contrib
- redhat-upgrade-postgresql-contrib-debuginfo
- redhat-upgrade-postgresql-debuginfo
- redhat-upgrade-postgresql-debugsource
- redhat-upgrade-postgresql-docs
- redhat-upgrade-postgresql-docs-debuginfo
- redhat-upgrade-postgresql-plperl
- redhat-upgrade-postgresql-plperl-debuginfo
- redhat-upgrade-postgresql-plpython3
- redhat-upgrade-postgresql-plpython3-debuginfo
- redhat-upgrade-postgresql-pltcl
- redhat-upgrade-postgresql-pltcl-debuginfo
- redhat-upgrade-postgresql-private-devel
- redhat-upgrade-postgresql-private-libs
- redhat-upgrade-postgresql-private-libs-debuginfo
- redhat-upgrade-postgresql-server
- redhat-upgrade-postgresql-server-debuginfo
- redhat-upgrade-postgresql-server-devel
- redhat-upgrade-postgresql-server-devel-debuginfo
- redhat-upgrade-postgresql-static
- redhat-upgrade-postgresql-test
- redhat-upgrade-postgresql-test-debuginfo
- redhat-upgrade-postgresql-test-rpm-macros
- redhat-upgrade-postgresql-upgrade
- redhat-upgrade-postgresql-upgrade-debuginfo
- redhat-upgrade-postgresql-upgrade-devel
- redhat-upgrade-postgresql-upgrade-devel-debuginfo
- Lightweight Endpoint Agent
- Live Dashboards
- Real Risk Prioritization
- IT-Integrated Remediation Projects
- Cloud, Virtual, and Container Assessment
- Integrated Threat Feeds
- Easy-to-Use RESTful API
- Automation-Assisted Patching
- Automated Containment
With Rapid7 live dashboards, I have a clear view of all the assets on my network, which ones can be exploited, and what I need to do in order to reduce the risk in my environment in real-time. No other tool gives us that kind of value and insight.
– Scott Cheney, Manager of Information Security, Sierra View Medical Center