Use of Dynamic Filter in Row Level Security

[mrityunjaya]

Hi

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?

[BrunoMueller]

hi

Have a look at the doc here https://go.documentation.sas.com/?docsetId=caspg&docsetTarget=p0hl1p1jnrmna0n1hx4lz5hbak8p.htm&docse... 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=n1mnqet3nld319n14jv2...

and here

https://go.documentation.sas.com/?cdcId=calcdc&cdcVersion=3.4&docsetId=calauthzcas&docsetTarget=n1bf...

[BrunoMueller]

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