IBM Support

Security Bulletin: Information Disclosure vulnerability affects IBM® DB2® LUW (CVE-2017-1150)

Security Bulletin


When a table is renamed and a new table is created with the old name, users who had access on the old table may be able to access the new table.

Vulnerability Details

A user may incorrectly acquire privileges on a table if the table is created with the same name as a previously renamed table. During a RENAME TABLE, a user maintains privileges on the renamed table. However, if a new table is then created with the old name, the user may also incorrectly maintain their privileges on this new table. The problem is caused by the rename operation not updating the user authorization cache. The error will be cleared up when the database is deactivated or when the DB2 instance is restarted.

For example:
User A is granted select privilege to table ABC.T1
An authorized user renames table ABC.T1 to ABC.T2
An authorized user creates a new table called ABC.T1
User A can correctly select from ABC.T2 (the new name for the renamed table) but will incorrectly gain the ability to select from ABC.T1 (new table)

CVEID: CVE-2017-1150
IBM DB2 for Linux, UNIX and Windows (includes DB2 Connect Server) could allow an authenticated attacker with specialized access to tables that they should not be permitted to view.
CVSS Base Score: 3.1
CVSS Temporal Score: See for the current score
CVSS Environmental Score*: Undefined
CVSS Vector: (CVSS:3.0/AV:N/AC:H/PR:L/UI:N/S:U/C:L/I:N/A:N)

Affected Products and Versions

All fix pack levels of IBM DB2 V10.1, V10.5 and V11.1 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® Direct Advanced Edition
IBM® DB2® Direct Standard 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.


The recommended solution is to apply the appropriate fix for this vulnerability.


The fix for DB2 and DB2 Connect release is in V10.1 FP6 is available for download from Fix Central.

Customers running any vulnerable fixpack level of an affected Program, V10.5 and V11.1 can download the special build containing the interim fix for this issue from Fix Central. These special builds are available based on the most recent fixpack level for each impacted release: DB2 V10.5 FP8 and DB2 V11.1.1 FP1. They can be applied to any affected fixpack level of the appropriate release to remediate this vulnerability.

Workarounds and Mitigations

Workaround #1
Recycling the database:

  • db2stop
  • db2start
Workaround #2
  1. Create a new table with the old table name.
    For each affected grantee:
    1. Grant the privilege(s) held by the grantee on the old table.
    2. Revoke the granted privilege(s) from step a.
    3. Drop the table created on step 1 (if not needed anymore).

Workaround #3
Revoke all the privileges from other grantees prior to the RENAME TABLE and re-grant the privileges to the grantees on the newly named table.

Get Notified about Future Security Bulletins



Change History

February 28, 2017: Original version published.
March 2, 2017: Clarified wordings in Vulnerability Details
April 27, 2017: Updated V11.1.1 iFix001 download URL.
October 11, 2017: Updated V10.5 download URL.

*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. In addition to other efforts to address potential vulnerabilities, IBM periodically updates the record of components contained in our product offerings. As part of that effort, if IBM identifies previously unidentified packages in a product/service inventory, we address relevant vulnerabilities regardless of CVE date. Inclusion of an older CVEID does not demonstrate that the referenced product has been used by IBM since that date, nor that IBM was aware of a vulnerability as of that date. We are making clients aware of relevant vulnerabilities as we become aware of them. "Affected Products and Versions" referenced in IBM Security Bulletins are intended to be only products and versions that are supported by IBM and have not passed their end-of-support or warranty date. Thus, failure to reference unsupported or extended-support products and versions in this Security Bulletin does not constitute a determination by IBM that they are unaffected by the vulnerability. Reference to one or more unsupported versions in this Security Bulletin shall not create an obligation for IBM to provide fixes for any unsupported or extended-support products or versions.

[{"Product":{"code":"SSEPGG","label":"Db2 for Linux, UNIX and Windows"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"--","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"}],"Version":"10.1;10.5;11.1","Edition":"Advanced Enterprise Server;Advanced Workgroup Server;Enterprise Server;Express;Express-C;Personal;Workgroup Server","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018