CVE-2009-3230: Medium severity postgresql common vulnerability

Published Sep 9, 2009
·
Updated

Quoting upstream PostgreSQL security page: http://www.postgresql.org/support/security.html

The fix for issue CVE-2007-2138 (below) failed to include protection against misuse of RESET SESSION AUTHORIZATION.

Affected versions: 8.4, 8.3, 8.2, 8.1, 8.0, 7.4 (note: this may affect previous 7.x versions too, but upstream does not support pre-7.4 versions any more)

Fixed in versions: 8.4.1, 8.3.8, 8.2.14, 8.1.18, 8.0.22, 7.4.26

Severity: C - A vulnerabilty that is exploitable for privilege escalation, but requiring a valid prior login.

CVE-2007-2138 was previously tracked via bug #237680 and bug #237682, more info on the updates addressing this flaw is available at: https://www.redhat.com/security/data/cve/CVE-2007-2138.html

Other sources

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.

Red Hat

Affected Software

89 affected componentsFixes available
redhat/postgresql<0:7.4.26-1.el4_8.1
0:7.4.26-1.el4_8.1
redhat/postgresql<0:8.1.18-2.el5_4.1
0:8.1.18-2.el5_4.1
PostgreSQL postgresql=7.4.16
PostgreSQL postgresql=8.1.10
PostgreSQL postgresql=8.1.6
PostgreSQL postgresql=8.2.9
PostgreSQL postgresql=8.0.7
PostgreSQL postgresql=8.0.2
PostgreSQL postgresql=8.1.15
PostgreSQL postgresql=8.1.7
PostgreSQL postgresql=8.3.6
PostgreSQL postgresql=8.2.10
PostgreSQL postgresql=7.4.24
PostgreSQL postgresql=8.2.4
PostgreSQL postgresql=7.4.22
PostgreSQL postgresql=7.4.21
PostgreSQL postgresql=8.0.17
PostgreSQL postgresql=8.0.10
PostgreSQL postgresql=7.4.19
PostgreSQL postgresql=8.1
PostgreSQL postgresql=8.2.11
PostgreSQL postgresql=8.1.13
PostgreSQL postgresql=8.0.12
PostgreSQL postgresql=8.2.12
PostgreSQL postgresql=7.4.15
PostgreSQL postgresql=8.0.9
PostgreSQL postgresql=8.0.15
PostgreSQL postgresql=7.4.1
PostgreSQL postgresql=8.2.2
PostgreSQL postgresql=8.3.3
PostgreSQL postgresql=8.1.3
PostgreSQL postgresql=7.4.14
PostgreSQL postgresql=7.4.6
PostgreSQL postgresql=8.3.2
PostgreSQL postgresql=7.4.23
PostgreSQL postgresql=7.4.11
PostgreSQL postgresql=8.0.18
PostgreSQL postgresql=8.2.5
PostgreSQL postgresql=8.0.3
PostgreSQL postgresql=7.4.7
PostgreSQL postgresql=8.1.9
PostgreSQL postgresql=7.4.17
PostgreSQL postgresql=8.4
PostgreSQL postgresql=7.4.3
PostgreSQL postgresql=8.2.1
PostgreSQL postgresql=8.3.1
PostgreSQL postgresql=8.1.14
PostgreSQL postgresql=7.4.25
PostgreSQL postgresql=7.4.9
PostgreSQL postgresql=7.4.5
PostgreSQL postgresql=7.4.18
PostgreSQL postgresql=8.3.5
PostgreSQL postgresql=8.0.20
PostgreSQL postgresql=8.0.8
PostgreSQL postgresql=7.4.8
PostgreSQL postgresql=8.2.7
PostgreSQL postgresql=8.0.6
PostgreSQL postgresql=8.1.11
PostgreSQL postgresql=7.4
PostgreSQL postgresql=8.2.6
PostgreSQL postgresql=7.4.4
PostgreSQL postgresql=8.0.16
PostgreSQL postgresql=8.3.7
PostgreSQL postgresql=8.0.13
PostgreSQL postgresql=8.1.4
PostgreSQL postgresql=8.0.1
PostgreSQL postgresql=8.1.8
PostgreSQL postgresql=8.3.4
PostgreSQL postgresql=7.4.12
PostgreSQL postgresql=8.0.19
PostgreSQL postgresql=8.1.1
PostgreSQL postgresql=8.1.12
PostgreSQL postgresql=8.1.5
PostgreSQL postgresql=8.0.21
PostgreSQL postgresql=7.4.10
PostgreSQL postgresql=8.1.16
PostgreSQL postgresql=8.2.3
PostgreSQL postgresql=8.0.4
PostgreSQL postgresql=8.0.5
PostgreSQL postgresql=7.4.20
PostgreSQL postgresql=8.0.14
PostgreSQL postgresql=8.2.8
PostgreSQL postgresql=8.2.13
PostgreSQL postgresql=8.2
PostgreSQL postgresql=7.4.2
PostgreSQL postgresql=8.0.11
PostgreSQL postgresql=8.0
PostgreSQL postgresql=7.4.13
PostgreSQL postgresql=8.1.2

Event History

Sep 9, 2009
CVE Published
via Red Hat·12:00 AM
Data Sourced
via Red Hat·01:10 PM
DescriptionSeverityAffected Software
Sep 17, 2009
CVE Published
via MITRE·10:00 AM
Data Sourced
via MITRE·10:00 AM
Description

Parent advisories

This vulnerability appears in the following advisories.

Frequently Asked Questions

1

What is the severity of CVE-2009-3230?

CVE-2009-3230 is rated as a medium severity vulnerability.

2

How do I fix CVE-2009-3230?

To fix CVE-2009-3230, upgrade your PostgreSQL version to 8.4.1 or higher, 8.3.8 or higher, 8.2.14 or higher, and so on as specified.

3

What versions of PostgreSQL are affected by CVE-2009-3230?

CVE-2009-3230 affects PostgreSQL versions 7.4 to 8.4, including various sub-versions.

4

Can CVE-2009-3230 be exploited remotely?

Yes, CVE-2009-3230 can be exploited remotely by authenticated users.

5

What operations are improperly handled in CVE-2009-3230?

CVE-2009-3230 involves improper privilege handling for the RESET ROLE and RESET SESSION AUTHORIZATION operations.

Contact

SecAlerts Pty Ltd.
132 Wickham Terrace
Fortitude Valley,
QLD 4006, Australia
info@secalerts.co
By using SecAlerts services, you agree to our services end-user license agreement. This website is safeguarded by reCAPTCHA and governed by the Google Privacy Policy and Terms of Service. All names, logos, and brands of products are owned by their respective owners, and any usage of these names, logos, and brands for identification purposes only does not imply endorsement. If you possess any content that requires removal, please get in touch with us.
© 2026 SecAlerts Pty Ltd.
ABN: 70 645 966 203, ACN: 645 966 203