I have three different data sources(A,B,C). I have these as LASR tables.These are the respective inputs in creating a report with three sections(A,B,C).
I need to define row level access for about 60 users. Each of these users will see different portions of the data. I know to create these row level definitions user by user and for each LASR table. My doubt is
1) Can I, in one go define the row level permission for all the users for a particular LASR table?. It could be as simple as if User 'X' logs in, he needs to see those rows where his USER ID appears(or) is the only way out, by defining them separately for 60 users?
2) Can i replicate these permissions on the other two LASR tables?
My effort if this doesn't work is 60 users*3 LASR Tables = 180 actions. I want to bring this down
There are some batch tools for metadata authorization to do this. Have a look at the row-level security section in the SAS Visual Analytics Administration Guide for the version of SAS VA you have at SAS Visual Analytics Documentation. You will need to get the user id and password from SAS Technical Support to access the document.
//Contact me to learn how Metacoda software can help keep your SAS platform secure - https://www.metacoda.com
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.