BookmarkSubscribeRSS Feed
ertefddfg
Calcite | Level 5

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.

1 REPLY 1
acordes
Rhodochrosite | Level 12

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;

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Discussion stats
  • 1 reply
  • 344 views
  • 0 likes
  • 2 in conversation