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

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

                               ESB-2018.3710
 IBM Db2's RCAC rules are not being enforced by CTAS sub-select statements
                             29 November 2018

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

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

Product:           IBM Db2
Publisher:         IBM
Operating System:  AIX
                   HP-UX
                   Solaris
                   Linux variants
                   Windows
Impact/Access:     Unauthorised Access -- Existing Account
Resolution:        Patch/Upgrade
CVE Names:         CVE-2018-1857  

Reference:         ESB-2018.3484.2

Original Bulletin: 
   https://www.ibm.com/support/docview.wss?uid=ibm10734059

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

Security Bulletin: IBM Db2's RCAC rules are not being enforced by CTAS
sub-select statements (CVE-2018-1857).

Document information

More support for: DB2 for Linux, UNIX and Windows

Software version: 11.1

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

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

Reference #: 0734059

Modified date: 28 November 2018

Security Bulletin


Summary

Db2's Row and Column Access Control (RCAC) rules are not being enforced when
creating a table using AS (CTAS) sub-select statements. RCAC is not enforced
when Db2 uses the 'WITH DATA' clause to select and insert data into the target
table.

Vulnerability Details

CVEID: CVE-2018-1857
DESCRIPTION: IBM DB2 for Linux, UNIX and Windows (includes DB2 Connect Server)
could allow a user to bypass FGAC control and gain access to data they
shouldn't be able to see.
CVSS Base Score: 4.8
CVSS Temporal Score: See https://exchange.xforce.ibmcloud.com/vulnerabilities/
151155 for the current score
CVSS Environmental Score*: Undefined
CVSS Vector: (CVSS:3.0/AV:N/AC:H/PR:L/UI:R/S:U/C:H/I:N/A:N)

Affected Products and Versions

All fix pack levels of IBM Db2 V11.1 editions on all platforms  are affected.

Remediation/Fixes

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

FIX:

The fix for DB2 release V11.1 is in V11.1.4.4, available for download from Fix
Central. 

+---------------+----------+----------+--------------------------------------------------------------------+
|Release        |Fixed in  |APAR      |Download URL                                                        |
|               |fix pack  |          |                                                                    |
+---------------+----------+----------+--------------------------------------------------------------------+
|V11.1          |FP4       |IT26595   |http://www.ibm.com/support/docview.wss-uid=ibm10741687              |
+---------------+----------+----------+--------------------------------------------------------------------+

Workarounds and Mitigations

None.

Reference

Complete CVSS v3 Guide
On-line Calculator v3

Related Information

IBM Secure Engineering Web Portal
IBM Product Security Incident Response Blog

Change History

November 5, 2018: Original version published.
November 28, 2018: Updated 11.1 version with a link to 11.1.4.4 image.

*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:

        https://www.auscert.org.au/bulletins/

===========================================================================
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

iQIVAwUBW/9bZmaOgq3Tt24GAQiy9Q//YUVVzk0kQgpG9xm19yM+wyENMA7i4+hD
5BQs5+jCa7hRa1HF5DFZDxTj8pDCs28blxPm9nMuHVomRq/XwnhYU1+5I+LaEsVS
LGwQfD3qnuI3CUC8PFBtJnddfW8Ct4tyG2HNLlYInn7R/DwuuDuCg+ZJo8eMyO02
AKBxqqHOPW+GfjNTiMuRmuX9B4hXcMVH9Q1KbfIR7Xmg/AgtPFbAAiYqjXaxJ6FI
ibverUzBoA30X3DYoRGe5okYVHgv467mG1eoK3S664nbiCqp64q73NzE/cCa6bBs
1PsjBfEYgWwrMNybVqnOT0HmdrcZpHhs2ANpcCLNJ9rFhQAKvxxf50QEYOUD9PlT
vjAg3ywJ2PMKTy0XqEUAuqN4GyyApiebqRvANDB/ee0xxqkd6EFUrCpWOLacqmnk
lsHpI6jjK/jyDnIROYm7c9TTNrGW5olYBcerJ6zuzLwcCqRP5cJhMMsYb3Z75Bst
B/0wZJHD73Y3KM6PQk30Fd+EAnSZkZNFJZZ5EUby+GagcWEwrO1aKwUnZP8QYYe2
juI73kvSf1BfUDpLBVL9OVP5Ouc6VBC4kwXyHsft0y0t33IpQorIzkbLPrO/R7Uj
bmH6fVYcclxzbv93gboKcmnYvFFhgRFE1tpY7maxx3wnoBrsXxmEcfmWdUTruZrp
rXW3NRM9r8s=
=+Z4C
-----END PGP SIGNATURE-----