Vulnerability Name:

CVE-2009-1239 (CCN-49864)

Assigned:2009-04-02
Published:2009-04-02
Updated:2017-08-17
Summary:IBM DB2 9.1 before FP7 returns incorrect query results in certain situations related to the order of application of an INNER JOIN predicate and an OUTER JOIN predicate, which might allow attackers to obtain sensitive information via a crafted query.
CVSS v3 Severity:5.3 Medium (CCN CVSS v3.1 Vector: CVSS:3.1/AV:N/AC:L/PR:N/UI:N/S:U/C:L/I:N/A:N)
Exploitability Metrics:Attack Vector (AV): Network
Attack Complexity (AC): Low
Privileges Required (PR): None
User Interaction (UI): None
Scope:Scope (S): Unchanged
Impact Metrics:Confidentiality (C): Low
Integrity (I): None
Availibility (A): None
CVSS v2 Severity:5.0 Medium (CVSS v2 Vector: AV:N/AC:L/Au:N/C:P/I:N/A:N)
3.7 Low (Temporal CVSS v2 Vector: AV:N/AC:L/Au:N/C:P/I:N/A:N/E:U/RL:OF/RC:C)
Exploitability Metrics:Access Vector (AV): Network
Access Complexity (AC): Low
Authentication (Au): None
Impact Metrics:Confidentiality (C): Partial
Integrity (I): None
Availibility (A): None
5.0 Medium (CCN CVSS v2 Vector: AV:N/AC:L/Au:N/C:P/I:N/A:N)
3.7 Low (CCN Temporal CVSS v2 Vector: AV:N/AC:L/Au:N/C:P/I:N/A:N/E:U/RL:OF/RC:C)
Exploitability Metrics:Access Vector (AV): Network
Access Complexity (AC): Low
Athentication (Au): None
Impact Metrics:Confidentiality (C): Partial
Integrity (I): None
Availibility (A): None
Vulnerability Type:CWE-200
Vulnerability Consequences:Obtain Information
References:Source: MITRE
Type: CNA
CVE-2009-1239

Source: AIXAPAR
Type: Patch
JR31886

Source: CCN
Type: IBM APAR JR31886
A QUERY MAY RETURN INCORRECT RESULTS WHEN ITS OUTER JOIN OPERATOR IS EXPECTED TO OUTPUT AT MOST ONE ROW.

Source: CONFIRM
Type: Patch, Vendor Advisory
http://www-01.ibm.com/support/docview.wss?uid=swg21381257

Source: CCN
Type: OSVDB ID: 54698
IBM DB2 Universal Database JOIN Predicate Query Result Handling Information Disclosure

Source: VUPEN
Type: Vendor Advisory
ADV-2009-0912

Source: XF
Type: UNKNOWN
db2-predicate-information-disclosure(49864)

Source: XF
Type: UNKNOWN
db2-predicate-information-disclosure(49864)

Source: CCN
Type: IBM Security Bulletin 6347588 (Security Guardium)
IBM Security Guardium is affected by multiple vulnerabilities

Vulnerable Configuration:Configuration 1:
  • cpe:/a:ibm:db2:9.1:-:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:*:connect_server:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:*:enterprise_server:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:*:express_server:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:*:personal:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:*:workgroup_server:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:fp1:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:fp1:unix:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:fp1:windows:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:fp2:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:fp3:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:fp3a:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:fp4:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:fp4a:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:fp5:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2:9.1:fp6:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2:*:fp6a:*:*:*:*:*:* (Version <= 9.1)

  • Configuration CCN 1:
  • cpe:/a:ibm:db2_universal_database:9.1:*:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2_universal_database:9.1:fp4:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2_universal_database:9.1:fp3:aix:*:*:*:*:*
  • OR cpe:/a:ibm:db2_universal_database:9.1:fp2:*:*:*:*:*:*
  • OR cpe:/a:ibm:db2_universal_database:9.1::fp3a:*:*:*:*:*
  • OR cpe:/a:ibm:db2_universal_database:9.1:fp4a:*:*:*:*:*:*
  • AND
  • cpe:/a:ibm:security_guardium:11.0:*:*:*:*:*:*:*
  • OR cpe:/a:ibm:security_guardium:11.1:*:*:*:*:*:*:*

  • * Denotes that component is vulnerable
    BACK
    ibm db2 9.1
    ibm db2 9.1
    ibm db2 9.1
    ibm db2 9.1
    ibm db2 9.1
    ibm db2 9.1
    ibm db2 9.1 fp1
    ibm db2 9.1 fp1
    ibm db2 9.1 fp1
    ibm db2 9.1 fp2
    ibm db2 9.1 fp3
    ibm db2 9.1 fp3a
    ibm db2 9.1 fp4
    ibm db2 9.1 fp4a
    ibm db2 9.1 fp5
    ibm db2 9.1 fp6
    ibm db2 * fp6a
    ibm db2 universal database 9.1
    ibm db2 universal database 9.1 fp4
    ibm db2 universal database 9.1 fp3
    ibm db2 universal database 9.1 fp2
    ibm db2 universal database 9.1
    ibm db2 universal database 9.1 fp4a
    ibm security guardium 11.0
    ibm security guardium 11.1