Hello Allan, Peter, The batchtool did the job (though it needed some extra tweaking). I had come across this earlier, but could not get it working. The -condition option failed from the example (after personallising it ofcourse). When I switched around the condition to: "(departmentname) IN ('SUB::SAS.IdentityGroups')", meaning I switched around the single and double qoutes, it worked like a charm. If not, I get the message: "Invalid commandline syntax. Too many objects specified.". As for Peter's solution: The amount of tables we have and the changes in responsibilities would make this a hard method to maintain. With each change in responsibility, we would need to change a lot of tables. I fine solution, but too maintenance heavy for our organisation. With the implemented solution, we can just shift users from one group/department to another and let the one time implementation on table level take over.
... View more