Security Features in PostgreSQL - CVE-2016-2193
Published: April 11, 2016 / Updated: August 9, 2020
Vulnerability details
The vulnerability allows a remote non-authenticated attacker to manipulate data.
PostgreSQL before 9.5.x before 9.5.2 does not properly maintain row-security status in cached plans, which might allow attackers to bypass intended access restrictions by leveraging a session that performs queries as more than one role.
Affected software
Amazon Linux AMI
Anolis OS
openEuler
IBM Security QRadar Network Threat Analytics
IBM Cloud Pak for Watson AIOps
Guardium Data Protection
IBM Sterling Connect:Direct Web Services
postgres-decoderbufs
pgaudit
pg_repack
postgresql-contrib
postgresql
postgresql-docs
postgresql-plperl
postgresql-pltcl
postgresql-test-rpm-macros
postgresql-upgrade-devel
postgresql-upgrade
postgresql-test
postgresql-static
postgresql-server-devel
postgresql-plpython3
postgresql-server
libpq
libpq-debuginfo
libpq-debugsource
libpq-devel
postgresql-private-libs
postgresql-private-devel
postgresql-llvmjit
postgresql-debugsource
postgresql-debuginfo
postgresql-13-static
postgresql-13
postgresql-13-contrib
postgresql-13-debuginfo
postgresql-13-debugsource
postgresql-13-docs
postgresql-13-test-rpm-macros
postgresql-13-test
postgresql-13-llvmjit
postgresql-13-server-devel
postgresql-13-server
postgresql-13-private-libs
postgresql-13-private-devel
postgresql-13-pltcl
postgresql-13-plpython3
postgresql-13-plperl
postgresql15
Juniper Secure Analytics (JSA)
How to mitigate CVE-2016-2193
IBM Sterling Connect:Direct Web Services - update to 6.1.0.27
postgres-decoderbufs - addressed in versions 0.10.0-2, 1.9.7-1.Final
pgaudit - addressed in versions 1.4.0-7, 1.5.0-1, 1.7.0-1
pg_repack - addressed in versions 1.4.6-3, 1.4.8-1
IBM Cloud Pak for Watson AIOps - update to 4.8.1
Juniper Secure Analytics (JSA) - update to 7.5.0 UP11 IF03
Guardium Data Protection - addressed in versions 12.0p35, 12.0p115
postgresql-contrib - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-docs - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-plperl - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-pltcl - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-test-rpm-macros - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-upgrade-devel - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-upgrade - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-test - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-static - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-server-devel - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-plpython3 - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-server - addressed in versions 12.22-1.0.1, 13.18-1.0.1, 15.10-1.0.1
postgresql-static - addressed in versions 13.17-1, 15.9-1
postgresql-test - addressed in versions 13.17-1, 15.9-1
postgresql-test-rpm-macros - addressed in versions 13.17-1, 15.9-1
libpq - addressed in versions 13.17-1, 15.9-1
libpq-debuginfo - addressed in versions 13.17-1, 15.9-1
libpq-debugsource - addressed in versions 13.17-1, 15.9-1
libpq-devel - addressed in versions 13.17-1, 15.9-1
postgresql - addressed in versions 13.17-1, 15.9-1
postgresql-server-devel - addressed in versions 13.17-1, 15.9-1
postgresql-server - addressed in versions 13.17-1, 15.9-1
postgresql-private-libs - addressed in versions 13.17-1, 15.9-1
postgresql-private-devel - addressed in versions 13.17-1, 15.9-1
postgresql-pltcl - addressed in versions 13.17-1, 15.9-1
postgresql-plpython3 - addressed in versions 13.17-1, 15.9-1
postgresql-plperl - addressed in versions 13.17-1, 15.9-1
postgresql-llvmjit - addressed in versions 13.17-1, 15.9-1
postgresql-docs - addressed in versions 13.17-1, 15.9-1
postgresql-debugsource - addressed in versions 13.17-1, 15.9-1
postgresql-debuginfo - addressed in versions 13.17-1, 15.9-1
postgresql-contrib - addressed in versions 13.17-1, 15.9-1
postgresql-13-static - update to 13.20-1
postgresql-13 - update to 13.20-1
postgresql-13-contrib - update to 13.20-1
postgresql-13-debuginfo - update to 13.20-1
postgresql-13-debugsource - update to 13.20-1
postgresql-13-docs - update to 13.20-1
postgresql-13-test-rpm-macros - update to 13.20-1
postgresql-13-test - update to 13.20-1
postgresql-13-llvmjit - update to 13.20-1
postgresql-13-server-devel - update to 13.20-1
postgresql-13-server - update to 13.20-1
postgresql-13-private-libs - update to 13.20-1
postgresql-13-private-devel - update to 13.20-1
postgresql-13-pltcl - update to 13.20-1
postgresql-13-plpython3 - update to 13.20-1
postgresql-13-plperl - update to 13.20-1
postgresql15 - update to 15.4-1
postgresql-private-libs - update to 15.10-1.0.1
postgresql-private-devel - update to 15.10-1.0.1
External References
Related Security Bulletins
- Multiple vulnerabilities in PostgreSQL
- openEuler 22.03 LTS SP1 update for postgresql
- openEuler 22.03 LTS SP3 update for postgresql
- openEuler 22.03 LTS SP4 update for postgresql
- openEuler 24.03 LTS update for postgresql
- openEuler 22.03 LTS SP4 update for libpq
- openEuler 24.03 LTS update for libpq
- openEuler 22.03 LTS SP1 update for libpq
- openEuler 22.03 LTS SP3 update for libpq
- Multiple vulnerabilities in IBM Cloud Pak for AIOps
- Amazon Linux AMI update for postgresql15
- Multiple vulnerabilities in IBM Sterling Connect:Direct Web Services
- Anolis OS update for postgresql:12 module
- Anolis OS update for postgresql:13 module
- Anolis OS update for postgresql:15 module
- openEuler 20.03 LTS SP4 update for postgresql-13
- Multiple vulnerabilities in IBM Guardium Data Protection
- Juniper Secure Analytics update for third-party components
- Multiple vulnerabilities in IBM Network Threat Analytics