DB2 - Problem description
Problem IC81387 | Status: Closed |
SECURITY: UNAUTHORIZED ACCESS TO TABLES | |
product: | |
DB2 FOR LUW / DB2FORLUW / 950 - DB2 | |
Problem description: | |
There is a security vulnerability in DB2 servers which an authenticated, malicious user to read data from a table for which they do not have the authority to view. To exploit this vulnerability, the user needs to have valid security credentials, and CONNECT and CREATEIN privileges to the database. | |
Problem Summary: | |
**************************************************************** * USERS AFFECTED: * * All DB2 systems on all Linux, Unix and Windows platforms at * * service levels from Version 9.5 GA through to Version 9.5 * * Fix Pack 8. * **************************************************************** * PROBLEM DESCRIPTION: * * See Error Description. * **************************************************************** * RECOMMENDATION: * * Upgrade to DB2 Version 9.5 Fix Pack 9 or see "Local Fix" * * portion for other suggestions. * **************************************************************** | |
Local Fix: | |
This vulnerability can be mitigated by revoking the CONNECT and CREATEIN privileges from PUBLIC. You can revoke the CONNECT and CREATEIN privileges from PUBLIC by issuing the following statements: revoke REVOKE CONNECT ON DATABASE FROM PUBLIC REVOKE IMPLICIT_SCHEMA ON DATABASE FROM PUBLIC | |
available fix packs: | |
DB2 Version 9.5 Fix Pack 9 for Linux, UNIX, and Windows | |
Solution | |
The complete fix for this problem first appears in DB2 Version 9.5 Fix Pack 9 and all the subsequent Fix Packs. | |
Workaround | |
not known / see Local fix | |
BUG-Tracking | |
forerunner : APAR is sysrouted TO one or more of the following: IC81390 IC81836 follow-up : | |
Timestamps | |
Date - problem reported : Date - problem closed : Date - last modified : | 13.02.2012 05.03.2012 06.03.2012 |
Problem solved at the following versions (IBM BugInfos) | |
9.5.FP9 | |
Problem solved according to the fixlist(s) of the following version(s) | |
9.5.0.9 |