IBM Support

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

Security Bulletin


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 Platform7.1.0Cloudera Data Platform 7.1.3, 7.1.4, 7.1.5, 7.1.7
IBM Big SQL on IBM Cloud Pak for Data7.1.1Cloud Pak for Data 3.5, 3.5 Refresh 1 - 9
IBM Big SQL on IBM Cloud Pak for Data7.2.0 - 7.2.3Cloud Pak for Data 4.0, 4.0 Refresh 1 - 3 
IBM Big SQL on IBM Cloud Pak for Data7.2.3Cloud 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 Platform7.1.0Cloudera Data Platform 7.1.3, 7.1.4, 7.1.5, 7.1.7Install Big SQL 7.1.0 APAR PH40808
IBM Big SQL on IBM Cloud Pak for Data7.1.13.5, 3.5 Refresh 1 -9Install Big SQL 7.1.1 patch 380
IBM Big SQL on IBM Cloud Pak for Data7.2.0 - 7.2.34.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 Data7.2.34.0 Refresh 4Update 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

Get Notified about Future Security Bulletins

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"}}]

Document Information

Modified date:
11 March 2022

UID

ibm16563021