E9.2 Roles and Objects report

[Debbie Phillips]

Hi
I'm sorry if this is simple question.
JDE920
I need to produce a report for Roles and the Objects contained within each role.
Is this possible from within the application? If so could anyone tell me how please?
Or do I need to create a script in Oracle SQL Developer. Again, if someone could tell me how this is done I've be very grateful - am new to Oracle SQL Developer.
Many thanks in advance
Debbie

 

[eydeak]

There have been some discussions about this before. Try searching for "SOX Audits".