Security Tables

I am trying to determine the table(s) that are accessed by the Security Workbench to set up action security by group/user in in J.D. Edwards OneWorld 8.9. I'd like to query all the information to determine the users/groups and the level of access they have to applications.

Thanks for any input...

Jason,
The Security workbench Application (P00950) accesses the Security Workbench Table F00950. A useful rule, in the technical area of JDE, is that the Program name and Table name are the same, except for the prefix. Another useful tool is the Cross Reference (if built) which is P980011, which can identify tables used by applications.

It's all in F00950.

The User to Group relationships can obviously be found in the F0092 table.

While the security assigned to specifc roles and/or userids is in the F00950, roles assigned to specific users is not. In 8.9 or above, you can assign 1-31 roles to a user, don't try 32 or the system will choke. In 8.9 and above, the assignment of role(s) to users in no longer obtained from the P0092, you use the P95921 for that purpose. If you use only a single role to a user analogus to the single group in XE, then research is relatively simple. However, if you take advanatge of multiple roles per user, then manual research becomes cumbersome. We designed a custom interactive app to show the security in all roles assigned to a user. Furthermore, we can do *all vs non-*all roles and perform role sequencing analysis in the same application. The time to design and code the app only took a couple of days.