BookmarkSubscribeRSS Feed
mrityunjaya
Obsidian | Level 7

 

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?

2 REPLIES 2
BrunoMueller
SAS Super FREQ

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

hackathon24-white-horiz.png

2025 SAS Hackathon: There is still time!

Good news: We've extended SAS Hackathon registration until Sept. 12, so you still have time to be part of our biggest event yet – our five-year anniversary!

Register Now

Discussion stats
  • 2 replies
  • 2463 views
  • 0 likes
  • 2 in conversation