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", "binaries": [ { "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", "binary_version": "10.23-0ubuntu0.18.04.2" } ] }
{ "availability": "No subscription required", "binaries": [ { "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", "binary_version": "12.15-0ubuntu0.20.04.1" } ] }
{ "availability": "No subscription required", "binaries": [ { "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", "binary_version": "14.8-0ubuntu0.22.04.1" } ] }