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