Row level conditions has been deleted

[vallsas]

Hi All,

one of the admin user has created row level condtions on multiple conditions but all of suddenly all the row level condtions been deleted . How to check why conditions has been deleted.

thanks in advance

[acordes]

In my experience it's recommendable to set the row-level security code-wise by saving the table to a sashdat file and running an adapted version of the following code. 

proc cas;
accessControl.updSomeAcsTable /
acs={
{caslib="onair" table="TY_9_SOLICITUDES_V16.sashdat" identity="RedComercial"
identitytype="Group" 
permtype="Grant"
permission="Select"
filter="strip(upcase(dkx))=('SUB::SAS.Userid')"}, 

{caslib="onair" table="TY_9_SOLICITUDES_V16.sashdat" identity="DirComercial"
identitytype="Group" 
permtype="Grant"
permission="Select"
filter="1=1"}
}
;
quit;

[vallsas]

thank you for the reply.

in my case i have assigned row-level filters for customgroups  on multiple tbales by using  my user  admin previleges, but one day all of sudden all my row-level filters has been cleared on all tables. I would like to know why thsi has happend.. please help in this regard.

thanks

[Madelyn_SAS]

Did you set the permissions on the in-memory table or the source file within the caslib? The best practice is to set table-level controls on persisted data (data that has been saved as a source file within a caslib), not on in-memory data. This topic discusses persistence of CAS access controls. 

https://go.documentation.sas.com/doc/en/sasadmincdc/v_060/calauthzcas/n1bf0cwn6ae85gn1b64x2j0czu24.h...