Hi, Requirement: All SAS users should not have access to all the tables from a particular SAS library. They should only see those tables that they are authorized to view. Rest of the tables should not be visible to these users through SAS Enterprise Guide. Solution: In order to achieve this, I have created ACTs (Access Control Templates) in the SAS management console and defined permissions for granting/denying access to particular table(s). I applied these ACTs manually on different SAS tables. These ACTs are working as expected, means wherever table access was denied through ACT, user is unable to see those tables. Challenge: Solution developed is working as expected, however challenge is that I need to apply these ACTs on a multiple tables. For example, if there are 500 tables within a particular library then set of users should not see 150 tables from this library. ACT need to be applied on these 150 tables. As an administrator it would be difficult to select each table manually and apply ACT. I am looking for the solution, whereby Access Control Template can be applied on these 150 tables in one go (probably through SAS code). I am not sure how to achieve this. Request your help, as I tried exploring various options on the internet but all the solutions gives information on how to creating ACT and applying it on library or object. I could not find solution where ACTs can be applied on multiple tables in one go. Regards,
... View more