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.
{ "availability": "No subscription required", "ubuntu_priority": "medium", "binaries": [ { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "libecpg-compat3" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "libecpg-compat3-dbgsym" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "libecpg-dev" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "libecpg-dev-dbgsym" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "libecpg6" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "libecpg6-dbgsym" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "libpgtypes3" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "libpgtypes3-dbgsym" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "libpq-dev" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "libpq5" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "libpq5-dbgsym" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-10" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-10-dbgsym" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-client-10" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-client-10-dbgsym" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-doc-10" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-plperl-10" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-plperl-10-dbgsym" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-plpython-10" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-plpython-10-dbgsym" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-plpython3-10" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-plpython3-10-dbgsym" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-pltcl-10" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-pltcl-10-dbgsym" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-server-dev-10" }, { "binary_version": "10.23-0ubuntu0.18.04.2", "binary_name": "postgresql-server-dev-10-dbgsym" } ] }
{ "availability": "No subscription required", "ubuntu_priority": "medium", "binaries": [ { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "libecpg-compat3" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "libecpg-compat3-dbgsym" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "libecpg-dev" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "libecpg-dev-dbgsym" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "libecpg6" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "libecpg6-dbgsym" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "libpgtypes3" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "libpgtypes3-dbgsym" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "libpq-dev" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "libpq5" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "libpq5-dbgsym" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-12" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-12-dbgsym" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-client-12" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-client-12-dbgsym" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-doc-12" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-plperl-12" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-plperl-12-dbgsym" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-plpython3-12" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-plpython3-12-dbgsym" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-pltcl-12" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-pltcl-12-dbgsym" }, { "binary_version": "12.15-0ubuntu0.20.04.1", "binary_name": "postgresql-server-dev-12" } ] }
{ "availability": "No subscription required", "ubuntu_priority": "medium", "binaries": [ { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "libecpg-compat3" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "libecpg-compat3-dbgsym" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "libecpg-dev" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "libecpg-dev-dbgsym" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "libecpg6" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "libecpg6-dbgsym" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "libpgtypes3" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "libpgtypes3-dbgsym" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "libpq-dev" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "libpq5" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "libpq5-dbgsym" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-14" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-14-dbgsym" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-client-14" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-client-14-dbgsym" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-doc-14" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-plperl-14" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-plperl-14-dbgsym" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-plpython3-14" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-plpython3-14-dbgsym" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-pltcl-14" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-pltcl-14-dbgsym" }, { "binary_version": "14.8-0ubuntu0.22.04.1", "binary_name": "postgresql-server-dev-14" } ] }