How do you pull a list of permissions from a user group (SQL)?

How do you pull a list of permissions from a user group?

There is no report in Enterprise Manager, so you must pull this data using database access. 

select ua.user_access_pk,
 s.screen_name,
 ua.screen_id,
 c.control_name,
 c.control_id,
 uga.access_allowed
 from t_user_group_access uga,
 t_user_access ua,
 t_screen s,
 t_control c
 where c.control_id = ua.control_id and
 s.screen_id = ua.screen_id and
 uga.user_access_pk = ua.user_access_pk and
 uga.user_group_pk in (select ug.user_group_pk from t_user_group ug where ug.user_group_name = 'Super User') /*Replace with User Group Name*/
 order by s.screen_name, c.control_name
 ; 

Related Articles

How do I get database access to CrunchTime?

Does Crunchtime allow users to delete User Groups?