IBM DB2 contains a denial of service vulnerability in which an ALTER TABLE statement on identity column may cause the DB2 server to terminate abnormally.
IBM DB2 contains a denial of service vulnerability. A remote, authenticated DB2 user could exploit this vulnerability by executing a specially-crafted ALTER TABLE statement on an identity column . This may cause DB2 server to terminate abnormally. To exploit the vulnerability, the malicious user needs to have valid security credentials to connect to DB2 and the authorization associated with the authorization ID of the connection would need to match one of the authorization scenarios listed below. Note that these authorities or privileges could be obtained by membership in a group or by assignment of certain role.
1) CONTROL or ALTER privilege on a table
The user would need either CONTROL or ALTER privilege on a table to execute the ALTER TABLE statement. Customer could consult the SYSCAT.TABAUTH table to determine the users, roles, and groups that have CONTROL privilege or ALTER privilege on a table. Furthermore, the owner of a table has implicit control privilege and the DBADM authority has implicit control privilege on all tables. Customer could look up owner of a table from the SYSCAT.TABLES table.
2) ALTERIN privilege on any schema that contains a table
User with this privilege could execute ALTER TABLE statement on any table in the schema. Customer could consult the SYSCAT.SCHEMAAUTH table to check for users, roles, and groups with this privilege. Also, customer could check the SYSCAT.TABLES for existence of tables in the schema.
3) CREATETAB authority on a database and USAGE privilege on at least one table space
With this authority, the user could create a table and then execute ALTER TABLE statement on that table. Customer could lookup the SYSCAT.DBAUTH table to find out users, roles, and groups with CREATETAB authority and check the SYSCAT.TBSPACEAUTH table for users, roles, and groups with USAGE privileges on table spaces.
CVSS Base Score: 6.3
CVSS Temporal Score: See https://exchange.xforce.ibmcloud.com/vulnerabilities/98684 for the current score
CVSS Environmental Score*: Undefined
CVSS Vector: (AV:N/AC:M/Au:S/C:N/I:N/A:C)
Affected Products and Versions
All fix pack levels of IBM DB2 V9.5, V9.7, V10.1 and V10.5 editions listed below and running on AIX, Linux, HP, Solaris or Windows are affected.
IBM DB2 Express Edition
IBM DB2 Workgroup Server Edition
IBM DB2 Enterprise Server Edition
IBM DB2 Advanced Enterprise Server Edition
IBM DB2 Advanced Workgroup Server Edition
IBM DB2 Connect™ Application Server Edition
IBM DB2 Connect™ Enterprise Edition
IBM DB2 Connect™ Unlimited Edition for System i®
IBM DB2 Connect™ Unlimited Edition for System z®
The DB2 Connect products mentioned are affected only if a local database has been created.
IBM DB2 pureScale™ Feature for Enterprise Server Edition, V9.8, running on AIX or Linux is affected.
The recommended solution is to apply the appropriate fix for this vulnerability.
The fix for DB2 and DB2 Connect V9.7 is in V9.7 FP11, V10.1 is in V10.1 FP5 and V10.5 is in V10.5 FP5, available for download from Fix Central.
Customers running any vulnerable fixpack level of an affected Program, V9.5 or V9.8 can contact support to obtain a special build containing an interim fix for this issue. These special builds are available based on the most recent fixpack level for each impacted release: DB2 V9.5 FP10 or DB2 V9.8 FP5. They can be applied to any affected fixpack level of the appropriate release to remediate this vulnerability. Additionally fixes based on DB2 V9.5 FP9, DB2 V9.7 FP10, DB2 V10.1 FP4 or V10.5 FP4 will be made available on request.
Refer to the folowing chart to determine how to proceed to obtain a needed fixpack or special build.
|Release||Fixed in fix pack||APAR||Download URL|
|V9.5||TBD||IT05644||Please contact technical support.|
|V9.8||TBD||IT05646||Please contact technical support.|
Contact Technical Support:
Note: IBM’s statements regarding its plans, directions, and intent are subject to change or withdrawal without notice at IBM’s sole discretion. Information regarding potential future products is intended to outline our general product direction and it should not be relied on in making a purchasing decision. The information mentioned regarding potential future products is not a commitment, promise, or legal obligation to deliver any material, code or functionality. Information about potential future products may not be incorporated into any contract. The development, release, and timing of any future features or functionality described for our products remains at our sole discretion.
Workarounds and Mitigations
Get Notified about Future Security Bulletins
December 11, 2014: Original Version Published
July 10, 2015: Updated with V10.1 FP5 fix info
Oct 2, 2015: Updated with V9.7 FP11 fix info
*The CVSS Environment Score is customer environment specific and will ultimately impact the Overall CVSS Score. Customers can evaluate the impact of this vulnerability in their environments by accessing the links in the Reference section of this Security Bulletin.
According to the Forum of Incident Response and Security Teams (FIRST), the Common Vulnerability Scoring System (CVSS) is an "industry open standard designed to convey vulnerability severity and help to determine urgency and priority of response." IBM PROVIDES THE CVSS SCORES ""AS IS"" WITHOUT WARRANTY OF ANY KIND, INCLUDING THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. CUSTOMERS ARE RESPONSIBLE FOR ASSESSING THE IMPACT OF ANY ACTUAL OR POTENTIAL SECURITY VULNERABILITY.
16 June 2018