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

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

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