Does anyone here know how to set up a SQL Query That will show me the groups in a project with the Users associated with that group?
I can't find a PK between the USERS.US_USERNAME and the GROUPS.GR_GROUP_NAME tables.
IT Quality Analyst
Lorillard Tobacco Company
Look at the schema db:
select * from td.USERS_GROUPS --ug_user_id = user_id
select * from td.USERS -- user_id
select * from td.USERS_PROJECTS -- user_id
All you need is there.
A user can be a member of multiple groups, so there is no direct link between USERS and GR_GROUP_NAME
To explain, a default QC project contains 5 user groups
numbered from zero to 4.
2 Project Manager
All USERS.US_GROUP values will be a 5 character string.
A user who is a member of the TDADmin group will have a 'group string' of 10000
A user who is a member of the TDADmin and Viewer groups will have a 'group string' of 10001
A user who is a member of the Project Manager and Viewer groups will have a 'group string' of 00101
... just another Tester ...
Have a look at http://www.sqaforums.com/showflat.ph...;Number=561986