CVE-2022-22353: Security Bulletin: Data masking rules are not enforced when CREATE TABLE AS SELECT statement is executed in IBM Big SQL

Summary

A software defect in IBM Big SQL prevents data masking rules to be enforced when a user executes CREATE TABLE AS (SELECT …) WITH DATA statement. The newly created table contains unmasked data.

Vulnerability Details

CVEID: CVE-2022-22353
DESCRIPTION: IBM Big SQL could allow an authenticated user with appropriate permissions to obtain sensitive information by bypassing data masking rules using a CREATE TABLE SELECT statement.
CVSS Base score: 5.3
CVSS Temporal Score: See: https://exchange.xforce.ibmcloud.com/vulnerabilities/220480 for the current score.
CVSS Vector: (CVSS:3.0/AV:N/AC:H/PR:L/UI:N/S:U/C:H/I:N/A:N)

Affected Products and Versions

Affected Product(s)

**Big SQL Version(s)
**

Platform Version(s)

IBM Big SQL on Cloudera Data Platform

7.1.0

Cloudera Data Platform 7.1.3, 7.1.4, 7.1.5, 7.1.7

IBM Big SQL on IBM Cloud Pak for Data

7.1.1

Cloud Pak for Data 3.5, 3.5 Refresh 1 - 9

IBM Big SQL on IBM Cloud Pak for Data

7.2.0 - 7.2.3

Cloud Pak for Data 4.0, 4.0 Refresh 1 - 3

IBM Big SQL on IBM Cloud Pak for Data

7.2.3

Cloud Pak for Data 4.0 Refresh 4

Remediation/Fixes

Product(s)

Big SQL Version(s)

Platform Versions(s)

Remediation/Fix/Instructions

IBM Big SQL on Cloudera Data Platform

7.1.0

Cloudera Data Platform 7.1.3, 7.1.4, 7.1.5, 7.1.7

Install Big SQL 7.1.0 APAR PH40808

IBM Big SQL on IBM Cloud Pak for Data

7.1.1

3.5, 3.5 Refresh 1 -9

Install Big SQL 7.1.1 patch 380

IBM Big SQL on IBM Cloud Pak for Data

7.2.0 - 7.2.3

4.0, 4.0 Refresh 1 - 3

Update to version 7.2.5 on Cloud Pak for Data 4.0 Refresh 5

IBM Big SQL on IBM Cloud Pak for Data

7.2.3

4.0 Refresh 4

Update to version 7.2.5 on Cloud Pak for Data 4.0 Refresh 5

IBM strongly advises to apply the remediation above.

Workarounds and Mitigations

None

References

Off

Change History

11 Mar 2022: Initial Publication

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

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSCRJT","label":"IBM Big SQL"},"Component":"","Platform":[{"code":"PF016","label":"Linux"}],"Version":"7.1, 7.2","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]