topic Re: Use of Dynamic Filter in Row Level Security in SAS Viya

Use of Dynamic Filter in Row Level Security

mrityunjaya — Tue, 02 Apr 2019 13:12:11 GMT

I have created a caslib and imported a dataset. The data set contains a column named 'users'. There are 500+ user id in that column.

I want to use dynamic filter by using Row Level Grant. Without creating 500+ users' id in Viya, how can I apply for row Level Grant So that all users can access the dashboard related to their field after login with their ID?

Re: Use of Dynamic Filter in Row Level Security

BrunoMueller — Wed, 03 Apr 2019 11:26:43 GMT

Have a look at the doc here https://go.documentation.sas.com/?docsetId=caspg&docsetTarget=p0hl1p1jnrmna0n1hx4lz5hbak8p.htm&docsetVersion=3.4&locale=en it shows an example of appliying a rule using substitution for the userid, so you only need one rule.

More details here: https://go.documentation.sas.com/?docsetId=caspg&docsetVersion=3.4&docsetTarget=n1mnqet3nld319n14jv2610m84bk.htm&locale=en

and here

https://go.documentation.sas.com/?cdcId=calcdc&cdcVersion=3.4&docsetId=calauthzcas&docsetTarget=n1bf0cwn6ae85gn1b64x2j0czu24.htm&locale=en#n1w8wywhavgjign18mezljnkb5oy

Re: Use of Dynamic Filter in Row Level Security

BrunoMueller — Thu, 15 Aug 2019 19:36:06 GMT

One can use the CAS action accessControl.isAuthorizedTables to show how the substitution parameter resolve.

proc cas;
  action accessControl.isAuthorizedTables /
    caslib="someLibrary"
    permission="Select"
    tables={"someTable.sashdat"}
  ;
run;
quit;

Of course it only shows the values of the user running this action