topic Re: SPD Server ACL Issue in SAS Programming

SPD Server ACL Issue

vijayanand — Thu, 13 Jun 2019 05:45:24 GMT

Hi All,

We recently have migrated SPD server tables from a Unix machine to a Linux Machine (SPD server was installed in Linux machine as well). For a specific schema (eg SCHEMA1) the user (user1) has only read access and the other user (user2) has write access as well. Hence we used “user2” to migrate the tables from Unix to Linux.

Now , when we access this scheme on the new linux server with the user “user1”, it says ACL read access to the dataset is required.

How to make user1 to be able to see the tables (which were migrated using user2) in schema1 on the new linux server.

Thanks,

Vijay.

Re: SPD Server ACL Issue

Kurt_Bremser — Thu, 13 Jun 2019 07:23:51 GMT

Look into the group ownerships of the files on both machines. Has something changed there?

(keep in mind that group ownership other than the primary group of the user can be forced through the "sticky bit" of the group being set on the parent directory)

But if ACL's were used on your old platform (can be determined by using the aclget command in eg AIX), you have to redo that on the new one.

See setfacl.

Re: SPD Server ACL Issue

LinusH — Thu, 13 Jun 2019 14:05:13 GMT

@Kurt_Bremser is mentioning AIX commands here, but SPDS security is held within the application, not in the OS.

But it is the same concept I would say. Check the SPDS user group membership on source and target for both users.

Then check what ACL settings are in effect for your data sets (again, compare source and target environments).