topic Re: Row level conditions has been deleted in SAS Visual Analytics

Row level conditions has been deleted

vallsas — Thu, 09 Jan 2025 06:31:18 GMT

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

Re: Row level conditions has been deleted

acordes — Tue, 21 Jan 2025 14:13:44 GMT

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;

Re: Row level conditions has been deleted

vallsas — Wed, 22 Jan 2025 07:40:39 GMT

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

Re: Row level conditions has been deleted

Madelyn_SAS — Wed, 29 Jan 2025 15:35:47 GMT

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.htm#n0x4ifvvufllarn151wfj32erz4q