Permissions, Privileges, and Access Controls in PostgreSQL - CVE-2009-3230
Published: October 10, 2018 / Updated: June 23, 2025
PostgreSQL
Detailed vulnerability description
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.
How to mitigate CVE-2009-3230
Sources
- 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