Environment access by user profile

Does anyone know of a standard JDE app or UBE that shows what users have access to certain environments? I couldn't find one. If one doesn't exist, has anyone built this on their own? Since we are assigning environments to user groups, we have to check what groups have access and then match up what users belong to those groups.

I don't know what your environment is like, since you didn't include it in your signature. Please do so for future posts, as it can affect the replies you get, as it does in this case.

We use Oracle for our database, and are on OW XE, as you can see in my signature. Here's a SQL command that will get you the users by environment, including the group they belong to. Hope this helps.

SELECT A.LLLL,B.ULUSER,A.LLUSER FROM SYS7333.F0093 A,SYS7333.F0092 B WHERE A.LLUSER=B.ULUGRP(+) ORDER BY 1,2,3;

Don, thanks for the help.

We are Windows/SQL Server 2000. Hopefully that shows below. I'll see if our SQL DBA can convert the Oracle SQL commands to SQL server.