E9.2 role and menu relationship extraction

[spiluttini]

hi all.
I need to extract all roles and all menu related .
Where this relation is stored? F0005/6
( i found that files in R90351)
.
I look on that files but field tdvaractive is always set to "N".
The R90351 is the answwer?
thanks in advanced

 

[lawrence_janes]

F9000 = Tasks
F9001 = Task Relationships
F9006 = Variants (Menu filtering by role is in here)

Tables were either designed by a genius or a fool - ie incredibly complex

Not sure if anyone on here has a documented cheat sheet to these 3 tables

Good Luck

 

[spiluttini]

thanks a lot

 

[eydeak]

I had to write some security reports back when SOX was brand new, and I subsequently posted some information in this thread. I believe all the basics are still true.

SOX audits - seeking answers

Hello All, We are now going through SOX compliance requirements. Can anyone provide any feedback as to what software you are using that helps you prepare when the auditors request info. So far, the questions have been JDE IDs, user roles, and application security related. We are on JDE 9.0...

www.jdelist.com

 

[StewartSchatz]

I had to write some security reports back when SOX was brand new, and I subsequently posted some information in this thread. I believe all the basics are still true.

SOX audits - seeking answers

Hello All, We are now going through SOX compliance requirements. Can anyone provide any feedback as to what software you are using that helps you prepare when the auditors request info. So far, the questions have been JDE IDs, user roles, and application security related. We are on JDE 9.0...

www.jdelist.com

Wow! That is great info and a very valuable resource! It's the most detailed report spec I've ever seen. Thanks!