SQL query to get the list of users in a project and their roles

select us_username, us_group, GR_Group_Name from users, Groups where substr(us_group,gr_group_id+1, 1)='1' order by 1

Note: above query is tested on Oracle database and Quality Center 10 patch 15