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.
{
"binaries": [
{
"binary_name": "libecpg-compat3",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "libecpg-dev",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "libecpg6",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "libpgtypes3",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "libpq-dev",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "libpq5",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "postgresql-9.3",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "postgresql-client-9.3",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "postgresql-contrib-9.3",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "postgresql-doc-9.3",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "postgresql-plperl-9.3",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "postgresql-plpython-9.3",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "postgresql-plpython3-9.3",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "postgresql-pltcl-9.3",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
},
{
"binary_name": "postgresql-server-dev-9.3",
"binary_version": "9.3.24-0ubuntu0.14.04+esm1"
}
]
}
{
"binaries": [
{
"binary_name": "libecpg-compat3",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "libecpg-dev",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "libecpg6",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "libpgtypes3",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "libpq-dev",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "libpq5",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "postgresql-9.5",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "postgresql-client-9.5",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "postgresql-contrib-9.5",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "postgresql-doc-9.5",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "postgresql-plperl-9.5",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "postgresql-plpython-9.5",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "postgresql-plpython3-9.5",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "postgresql-pltcl-9.5",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
},
{
"binary_name": "postgresql-server-dev-9.5",
"binary_version": "9.5.25-0ubuntu0.16.04.1+esm10"
}
]
}
{
"binaries": [
{
"binary_name": "libecpg-compat3",
"binary_version": "10.23-0ubuntu0.18.04.2"
},
{
"binary_name": "libecpg-dev",
"binary_version": "10.23-0ubuntu0.18.04.2"
},
{
"binary_name": "libecpg6",
"binary_version": "10.23-0ubuntu0.18.04.2"
},
{
"binary_name": "libpgtypes3",
"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": "postgresql-10",
"binary_version": "10.23-0ubuntu0.18.04.2"
},
{
"binary_name": "postgresql-client-10",
"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-plpython-10",
"binary_version": "10.23-0ubuntu0.18.04.2"
},
{
"binary_name": "postgresql-plpython3-10",
"binary_version": "10.23-0ubuntu0.18.04.2"
},
{
"binary_name": "postgresql-pltcl-10",
"binary_version": "10.23-0ubuntu0.18.04.2"
},
{
"binary_name": "postgresql-server-dev-10",
"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-dev",
"binary_version": "12.15-0ubuntu0.20.04.1"
},
{
"binary_name": "libecpg6",
"binary_version": "12.15-0ubuntu0.20.04.1"
},
{
"binary_name": "libpgtypes3",
"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": "postgresql-12",
"binary_version": "12.15-0ubuntu0.20.04.1"
},
{
"binary_name": "postgresql-client-12",
"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-plpython3-12",
"binary_version": "12.15-0ubuntu0.20.04.1"
},
{
"binary_name": "postgresql-pltcl-12",
"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-dev",
"binary_version": "14.8-0ubuntu0.22.04.1"
},
{
"binary_name": "libecpg6",
"binary_version": "14.8-0ubuntu0.22.04.1"
},
{
"binary_name": "libpgtypes3",
"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": "postgresql-14",
"binary_version": "14.8-0ubuntu0.22.04.1"
},
{
"binary_name": "postgresql-client-14",
"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-plpython3-14",
"binary_version": "14.8-0ubuntu0.22.04.1"
},
{
"binary_name": "postgresql-pltcl-14",
"binary_version": "14.8-0ubuntu0.22.04.1"
},
{
"binary_name": "postgresql-server-dev-14",
"binary_version": "14.8-0ubuntu0.22.04.1"
}
],
"availability": "No subscription required"
}