Problem Note 68886: A profile in SAS® Data Explorer in SAS® Viya® 3.5 should not return results if row-level security is enabled on the table
 |  |  |  |  |
If row-level security is enabled for a table in SAS Viya, then a profile on the table should not return results. Profile results in this case are misleading, because all of the statistics in the profile report are based only on the rows that you are enabled to access.
If you want to profile only a subset of rows, create a new table that consists of only those rows and then run a profile on that separate table. If you have full access to all rows in the table, then you can create a copy of the table and profile the table without row-level security enabled.
After the hot fix in this note is applied, the profile action in SAS Data Explorer is updated to return an error message that states that tables with row-level security cannot be profiled.
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 Viya | Linux for x64 | 3.5 | 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=softwareUpdates| Type: | Problem Note |
| Priority: | high |
| Date Modified: | 2022-02-10 10:15:03 |
| Date Created: | 2022-02-07 09:23:11 |