Problem Note 67754: The option setting for the options used to connect to Google BigQuery with OAuth authentication might be displayed in clear text in logs
 |  |  |  |  |
Severity: Critical
Description: The ability to use OAuth authentication to connect to Google BigQuery is done through the use of the REFRESH_TOKEN=, CLIENT_ID= and CLIENT_SECRET= LIBNAME and CASLIB options. The settings for these options might be displayed in the SAS® log.
Potential Impact: A user's logon credentials might be exposed in clear text.
Click the Hot Fix tab in this note for a link to instructions about accessing and applying the software update.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS/ACCESS Interface to Google BigQuery | Linux for x64 | 9.41 | 9.43 | 9.4 TS1M6 | 9.4 TS1M8 |
| SAS System | SAS/ACCESS Interface to Google BigQuery (on SAS Viya) | Linux for x64 | V.03.05 | 2021.1.1 | Viya | Viya |
| SAS System | SAS Data Connector to Google BigQuery | Linux for x64 | V.03.05 | 2020.1.5 | Viya | Viya |
Viya on Windows: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Windows Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesWinViya on Linux: An update for this issue is available for SAS Viya 3.5. For instructions on how to access and apply software updates, see the Updating Your SAS Viya software section in the SAS Viya 3.5 for Linux Deployment Guide at
http://documentation.sas.com/?softwareId=administration&softwareVersion=3.5&softwareContextId=softwareUpdatesA fix for this issue for SAS/ACCESS Interface to Google BigQuery 9.42 is available at:
https://tshf.sas.com/techsup/download/hotfix/HF2/K2L.html#67754| Type: | Problem Note |
| Priority: | alert |
| Date Modified: | 2021-05-26 16:14:37 |
| Date Created: | 2021-04-09 09:30:08 |