Permissions, Privileges, and Access Controls in PostgreSQL - CVE-2009-3230
Published: October 10, 2018 / Updated: June 23, 2025
Vulnerability identifier: #VU111776
CSH Severity: Medium
CVSS v4: 5.3 [CVSS:4.0/AV:N/AC:L/AT:N/PR:L/UI:N/VC:L/VI:L/VA:L/SC:N/SI:N/SA:N]
CVE-ID: CVE-2009-3230
CWE-ID: CWE-264
Exploitation vector: Remote access
Exploit availability:
No public exploit available
Vulnerability details
The vulnerability allows a remote user to read and manipulate data.
The core server component in PostgreSQL 8.4 before 8.4.1, 8.3 before 8.3.8, 8.2 before 8.2.14, 8.1 before 8.1.18, 8.0 before 8.0.22, and 7.4 before 7.4.26 does not use the appropriate privileges for the (1) RESET ROLE and (2) RESET SESSION AUTHORIZATION operations, which allows remote authenticated users to gain privileges. NOTE: this is due to an incomplete fix for CVE-2007-6600.
Affected software
PostgreSQL
Gentoo Linux
dev-db/postgresql
dev-db/postgresql-server
Gentoo Linux
dev-db/postgresql
dev-db/postgresql-server
How to mitigate CVE-2009-3230
Install update from vendor's website.
PostgreSQL - addressed in versions 7.4.26, 8.0.22, 8.1.18, 8.2.14, 8.3.8, 8.4.1
dev-db/postgresql - update to 9.0.5
dev-db/postgresql-server - update to 9.0.5
dev-db/postgresql - update to 9.0.5
dev-db/postgresql-server - update to 9.0.5
External References
- http://archives.postgresql.org/pgsql-www/2009-09/msg00024.php
- http://lists.opensuse.org/opensuse-security-announce/2009-10/msg00001.html
- http://lists.opensuse.org/opensuse-security-announce/2009-10/msg00004.html
- http://marc.info/?l=bugtraq&m=134124585221119&w=2
- http://secunia.com/advisories/36660
- http://secunia.com/advisories/36695
- http://secunia.com/advisories/36727
- http://secunia.com/advisories/36800
- http://secunia.com/advisories/36837
- http://sunsolve.sun.com/search/document.do?assetkey=1-66-270408-1
- http://wiki.rpath.com/wiki/Advisories:rPSA-2010-0012
- http://www.postgresql.org/docs/8.3/static/release-8-3-8.html
- http://www.postgresql.org/support/security.html
- http://www.securityfocus.com/archive/1/509917/100/0/threaded
- http://www.securityfocus.com/bid/36314
- http://www.ubuntu.com/usn/usn-834-1
- http://www.us.debian.org/security/2009/dsa-1900
- http://www.vupen.com/english/advisories/2009/2602
- https://bugzilla.redhat.com/show_bug.cgi?id=522085
- https://oval.cisecurity.org/repository/search/definition/oval%3Aorg.mitre.oval%3Adef%3A10166
- https://www.redhat.com/archives/fedora-package-announce/2009-September/msg00305.html
- https://www.redhat.com/archives/fedora-package-announce/2009-September/msg00307.html