topic Row Level Security IN VA Report in SAS Visual Analytics

Row Level Security IN VA Report

Rupasree — Wed, 30 Mar 2016 10:41:10 GMT

Hi All,

We have a requirement ,where we need to restrict the rows based on the group of the user logged i.e. if the user A has logged on to access the report and if he belongs to group "GroupA" then he will be allowed see the data where Flag=1 in the chart or else he will see the data where Flag=0.

To achieve the same, i have written the below rule to authorise the data&colon;

('UID'n = 'SUB::SAS.PersonName') AND (((Flag=1) AND ('SUB::SAS.IdentityGroups' Contains 'GroupA')) OR

((Flag=0) AND ('SUB::SAS.IdentityGroups' NotContains 'GroupA')) )

But, the chart throws an error with Invalid Data.

I changed the rule to figure out where is the error :

('UID'n = 'SUB::SAS.PersonName') AND ((Flag=1) OR (Flag=0))

With the modified rule data is displayed in the chart though not the correct data but without any error.

Please help us to figure out the error in the above rule.

Your help is highly appreciated.

Regards,

Rupasree

Re: Row Level Security IN VA Report

LinusH — Wed, 30 Mar 2016 11:03:38 GMT

Seems to be a missing space between Not and Contains. Just in the post?

Re: Row Level Security IN VA Report

Rupasree — Mon, 18 Apr 2016 07:10:53 GMT

Hi All,

The above issue was solved by using sas-metadata-access batch tool.The below link gives more information about batch tool:

http://support.sas.com/resources/papers/proceedings15/SAS1779-2015.pdf

Regards,

Rupasree

Re: Row Level Security IN VA Report

balraj — Mon, 18 Apr 2016 07:59:42 GMT

Hi @Rupasree

Thanks for your reply, I've successfully implemented it. Check this link

https://communities.sas.com/t5/SAS-Visual-Analytics/Filter-using-Logged-In-User/m-p/264493#M3925

Kind Regards,

Balraj