Security restrictions bypass in PostgreSQL - CVE-2021-20229
Published: February 11, 2021
Vulnerability details
The vulnerability allows a remote user to gain access to sensitive information.
The vulnerability exists due to application does not properly impose security restrictions. A user having a SELECT privilege on an individual column can craft a special
query that returns all columns of the table. Additionally, a stored view that uses column-level privileges will have
incomplete column-usage bitmaps. In installations that depend on column-level
permissions for security, it is recommended to execute CREATE OR REPLACE on
all user-defined views to force them to be re-parsed.
Affected software
Arch Linux
Gentoo Linux
openEuler
postgresql (Alpine package)
postgresql-plperl
postgresql-static
postgresql-devel
postgresql-test-rpm-macros
postgresql-contrib
postgresql-pltcl
postgresql-server
postgresql-libs
postgresql-plpython3
postgresql-debugsource
postgresql-help
postgresql-debuginfo
postgresql-test
postgresql
Dell Security Management Server
How to mitigate CVE-2021-20229
postgresql (Alpine package) - update to 13.2-r0
postgresql-plperl - update to 10.5-20
postgresql-static - update to 10.5-20
postgresql-devel - update to 10.5-20
postgresql-test-rpm-macros - update to 10.5-20
postgresql-contrib - update to 10.5-20
postgresql-pltcl - update to 10.5-20
postgresql-server - update to 10.5-20
postgresql-libs - update to 10.5-20
postgresql-plpython3 - update to 10.5-20
postgresql-debugsource - update to 10.5-20
postgresql-help - update to 10.5-20
postgresql-debuginfo - update to 10.5-20
postgresql-test - update to 10.5-20
postgresql - update to 10.5-20
Dell Security Management Server - update to 11.0.1