topic Re: Row level security and ad groups in SAS Visual Analytics

Row level security and ad groups

jjmccoydk — Wed, 08 May 2019 13:11:09 GMT

Hey VA experts.

I have an issue, that i would like some help to.

senario.

this is my table i VA.

I have to have row level seccurity couse GDPR. One ad group is fine but serverel AD groups i my table - i can not use in sub:xxxx,

We are a large organization with + 500 ad group, so it is import to use ad group instead of userid.

any suggestions og link til document how can help me

John Mortensen

FredrikE — Wed, 08 May 2019 15:46:44 GMT

Hi!

One way to do this could be to create a RLS-statement for each group.

Lets take group 10 as an example.

For this group you add a RLS-statment like:

ad_group contains '10'

This is a bit unsafe because '2010' and '110' will also be selected.

If you make sure that all values have a delimiter you could use ad_group contains ',10' for example.

You can create all groups and RLS-statments by using a script so it will become fully dynamic 🙂

//Fredrik