Re: How to extract an Specific zSecure Audit Report!
Posted: Tue Apr 23, 2019 1:25 pmAs in the previous example, I think you need to come at this from the angle of "which users have access to every resource" as opposed to "what access does every user have". So, the previous example gives you that at a group level, you just need that expanded out to individual users? In which case, just add the EXPLODE operand to the ACL parameter. And you may also want to include the UACC in the report output so you know that every user will have access. So, just change the last line to this -
sortlist key acl(explode) uacc
Obviously it's going to be a massive report. We only have 10k users, and that ran to 17m lines, although it will probably depend more on the number of profiles than the number of users. And that was just for DATASET profiles. And then you need to think about who has access via OPERATIONS or anything else....
sortlist key acl(explode) uacc
Obviously it's going to be a massive report. We only have 10k users, and that ran to 17m lines, although it will probably depend more on the number of profiles than the number of users. And that was just for DATASET profiles. And then you need to think about who has access via OPERATIONS or anything else....