E9.2 Visualize JDE security?

[MFreitag]

Hi all,
i was wondering if anybody is visualizing their security in a matrix, spreadsheet, BI report whatsoever. I'm after the question "What exactly is <THIS> role allowed to do?". I can get a lot out of F00950 via SQL, for sure, but how about some nice clean spreadsheets?
If you know any software product that does this, or maybe just 70% of this, i'm also all ears.

Cheers,
schojo

 

[Kim Schmidt]

My last two companies have been using AllOut Security - besides the improved ease of use versus the JDE security workbench, they offer a number of reports that can be used for Separation of Duty analysis, and point out potential conflicts as sometimes occur when users have multiple roles.

 

[eydeak]

I've worked for companies that use AllOut as well. If you want to take a stab at writing your own security report, try searching for "SOX Audits".

 

[MFreitag]

Thank you both!
@eydeak - your download still worked, cheers

Just looked at it - I've even been on that exact JDE system before, funny!

 

[BPConnor]

As the others have said, ALLOut Security provides several great tools you can use. I think one of the best ways to look at the security for a particular role is via the security supergrid where you have the option of "merging" multiple security types to a single line. This means you can see Application and Action in a single line with only the column data that is pertinent to those security types. You can also select a checkbox on the screen to limit the results to only roles or only users (helpful when the user and role naming conventions are co-mingled). Once there, you can of course export the data to Excel.