-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA256

===========================================================================
             AUSCERT External Security Bulletin Redistribution

                               ESB-2017.0568
          Security Bulletin: Table privilege checking may return
         outdated results after a table is renamed (CVE-2017-1150)
                               3 March 2017

===========================================================================

        AusCERT Security Bulletin Summary
        ---------------------------------

Product:           IBM DB2 for Linux, UNIX and Windows
Publisher:         IBM
Operating System:  AIX
                   HP-UX
                   Linux variants
                   Solaris
                   Windows
Impact/Access:     Increased Privileges -- Existing Account
Resolution:        Patch/Upgrade
CVE Names:         CVE-2017-1150  

Original Bulletin: 
   http://www.ibm.com/support/docview.wss?uid=swg21999515

- --------------------------BEGIN INCLUDED TEXT--------------------

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

Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 10.1, 10.5, 11.1

Operating system(s): AIX, HP-UX, Linux, Solaris, Windows

Software edition: Advanced Enterprise Server, Advanced Workgroup Server,
Enterprise Server, Express, Express-C, Personal, Workgroup Server

Reference #: 1999515

Modified date: 02 March 2017

Security Bulletin

Summary

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
DESCRIPTION: 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
https://exchange.xforce.ibmcloud.com/vulnerabilities/122291 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.

Remediation/Fixes

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

FIX:

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.


Release		Fixed in fix pack	APAR		Download URL
V10.1		FP6			IT15485		http://www.ibm.com/support/docview.wss?uid=swg24043366
V10.5		TBD			IT19399		Special Build for V10.5 FP8:
							AIX 64-bit
							HP-UX 64-bit
							Linux 64-bit, x86-64
							Linux 64-bit, POWER big endian
							Linux 64-bit, POWER little endian
							Linux 64-bit, System z, System z9 or zSeries
							Solaris 64-bit, SPARC
							Solaris 64-bit, x86-64
							Windows 32-bit, x86
							Windows 64-bit, x86

Contact technical support for the following platforms:

    Inspur
    Linux 32-bit, x86-32

V11.1.1			TBD		IT19400		Special Build for V11.1.1 FP1:
							AIX 64-bit
							Linux 64-bit, x86-64
							Linux 64-bit, POWER little endian
							Linux 64-bit, System z, System z9 or zSeries
							Windows 64-bit, x86

Workarounds and Mitigations

Workaround #1
Recycling the database:

    db2stop
    db2start

Workaround #2

    Create a new table with the old table name.

    For each affected grantee:
	Grant the privilege(s) held by the grantee on the old table.
	Revoke the granted privilege(s) from step a.
	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

Subscribe to My Notifications to be notified of important product support
alerts like this.
References
Complete CVSS v3 Guide
On-line Calculator v3

Related information
IBM Secure Engineering Web Portal
IBM Product Security Incident Response Blog

Change History

February 28, 2017: Original version published.
March 2, 2017: Clarified wordings in Vulnerability Details

*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.
Disclaimer

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.

- --------------------------END INCLUDED TEXT--------------------

You have received this e-mail bulletin as a result of your organisation's
registration with AusCERT. The mailing list you are subscribed to is
maintained within your organisation, so if you do not wish to continue
receiving these bulletins you should contact your local IT manager. If
you do not know who that is, please send an email to auscert@auscert.org.au
and we will forward your request to the appropriate person.

NOTE: Third Party Rights
This security bulletin is provided as a service to AusCERT's members.  As
AusCERT did not write the document quoted above, AusCERT has had no control
over its content. The decision to follow or act on information or advice
contained in this security bulletin is the responsibility of each user or
organisation, and should be considered in accordance with your organisation's
site policies and procedures. AusCERT takes no responsibility for consequences
which may arise from following or acting on information or advice contained in
this security bulletin.

NOTE: This is only the original release of the security bulletin.  It may
not be updated when updates to the original are made.  If downloading at
a later date, it is recommended that the bulletin is retrieved directly
from the author's website to ensure that the information is still current.

Contact information for the authors of the original document is included
in the Security Bulletin above.  If you have any questions or need further
information, please contact them directly.

Previous advisories and external security bulletins can be retrieved from:

        http://www.auscert.org.au/render.html?cid=1980

===========================================================================
Australian Computer Emergency Response Team
The University of Queensland
Brisbane
Qld 4072

Internet Email: auscert@auscert.org.au
Facsimile:      (07) 3365 7031
Telephone:      (07) 3365 4417 (International: +61 7 3365 4417)
                AusCERT personnel answer during Queensland business hours
                which are GMT+10:00 (AEST).
                On call after hours for member emergencies only.
===========================================================================
-----BEGIN PGP SIGNATURE-----
Comment: http://www.auscert.org.au/render.html?it=1967

iQIVAwUBWLjWtYx+lLeg9Ub1AQirBA//RiMjjAnQRFTdZkecI60WrefAq8ip9S6q
/xzLQc1KgpPmKuMzWwgtPQiiTbd28iFdYSUVcmTu+OA0pa/hMl49uA60cwYGayZG
nQxxCmOR1OTPYk+kxD3ktmaVtfBH1NtgPc4FFkIvcRYbo3RWN1wAQE/0k1U7JSG6
bHOPaep14hyoaCoH9Z81Jdufi+TPu4FMWL6PVFsjYu+rALpnlgjl0PasTRaWXl9M
0+pLv7jFDcgnHRmGrulPHD97zQTY4yN8ALtCNz6AShKY6SmMq3AzfuET6ir7OCIz
QkC8Rnvs08zMHtUd+fC4XyT+O2OPyghW6NQLi9qO8D6MFcrDfSDb7I05ETu+GOov
KhtZeKdPbA/vy4fNdI1VOoGR9dE/epHZc/3Ed4NukIjzVjHyj9xHw7vfv7IUg6kI
1e0HJbO/HIw4qDWv9aeDU+YGwwvMSHm5Vrpl4MimZKlxHGbzthp1DxxyrJVbiueQ
THGc88Ri4IH6eXYwtLTbg+RTLNECaVlzcOlfidqxfCmQ9+ycD7Te6IvNe279En2E
nViSOXzh2jwav4iJlqleemClEnYEN4EZ13raDOQ41XqQtRy4tMHv1u0Xiv0GWS3K
zNAXNdHLWEFqipqvf7xBQGMiylt4rRRXYjob3xwu5Prb1OJ3kH6LWew5XrVnd2yh
cWg/kfMV0dI=
=UeBx
-----END PGP SIGNATURE-----