Users and environemnts- SOX reqs

Shazza

Active Member
Hello all,

as part of the "SOX" requirements we need to be able to show the auditor which users within JDE have access to which environments. eg. Prod, test, crp, etc. Can anyone tell me which table this info is stored in?
Thanks
 
It used to be F0093 in Xe. Not sure if it is the same in 8.10. You can do a join between the tables to get environments by user. Also, I believe that there is a standard report that gives you this info as well. I'll try to find it and post it later.

Dan
 
You are right. It is still the F0093 in the System datasource.
Perhaps the R00921 report will help you.
Regards,
Loïc
 
Back
Top