Hi Everyone,
I have come across this blog post from Michelle: https://www.metacoda.com/en/2014/01/conditional-grants-sas-visual-analytics/ which I found useful in implementing Row-Level Security.
I just need some help in tweaking the method in a way that allows different group of users to see different data from the other. This is more on the hierarchy of the user groups. Let's say we have two different columns from our table, namely: Group, and Department. Then we have two user groups that accesses the exploration, for example Group Heads and Department Heads. Each user in the Group Heads user group accesses data based on the column Group, whilst Department Heads acccesses based on Department. The thing now is that the data for the Group Heads should show the data item value from Group column, while the Deapartment shows the data item value from Department column.
Is there a way to implement this on a single exploration to show the data from either of the two columns (data items) based on the user group the current user belongs to? By the way, I am using SAS VA 7.1.
Thanks,
Carrot17
... View more