Hi experts,
I was sure that permissions set directly on an in-memory CAS table (not on the ".sashdat" file) are not persistent across table unload and re-load actions but to my surprise testing this showed that the CAS permissions were preserved across unload/load of the in-memory table. I am wondering if my testing is perhaps wrong or maybe this is the correct behavior.
For example, here is my test code:
/* load and promote table without saving it as sashdat file */ data samples.class(promote=yes);
set sashelp.class;
run;
/* set permissions directly on the in-memory table */
proc cas;
session casauto;
accessControl.assumeRole / adminRole="superuser";
accessControl.updSomeAcsTable /
acs={
{caslib="samples",
table="class",
identity="gonen",
identityType="User",
permType="Grant",
permission="Select",
filter="name='SUB::SAS.Userid'"}};
run;quit; /* unload table */
proc casutil;
droptable casdata="class" incaslib="samples" ;
run;quit;
/* load again and check permissions and see they are preserved */
data samples.class(promote=yes);
set sashelp.class;
run;
... View more