topic Re: Visual Analytics reports in SAS Viya

Visual Analytics reports

ertefddfg — Tue, 16 Jan 2024 04:06:40 GMT

Hello,

We are looking to find out if we can implement role based or user based access restrictions of a Visual Analytics report content.
1) One of our requirement is that a group of users will have access to a report which has various tabs inside it. So, is it possible to restrict certain tabs access to only a set of users who has access to report and not everyone who has access?
2) Can we restrict the users access to the data used in the report? So, if a report used 6 data tables, can a set of users be given access to only 5 tables and show only certain portion of the report content that uses the 5 tables that hey have access to?

Please clarify us if there is any way to achieve our above requirements.

Re: Visual Analytics reports

acordes — Tue, 16 Jan 2024 09:21:29 GMT

Yes, we solved this by running the following code:

You have to work closely with the admin of SAS Viya to create user groups and assign users to them.

The tables whose content we want to lock for unauthorized access we use at row-level the same UserId than it appears in the sas viya administration.

proc cas;
accessControl.updSomeAcsTable /
acs={
{caslib="onair" table="TY_9_SOLICITUDES_V16.sashdat" identity="RedComercial"
identitytype="Group" 
permtype="Grant"
permission="Select"
filter="strip(upcase(dkx))=('SUB::SAS.Userid')"}, 

{caslib="onair" table="TY_9_SOLICITUDES_V16.sashdat" identity="DirComercial"
identitytype="Group" 
permtype="Grant"
permission="Select"
filter="1=1"}
}
;
quit;