User - group information on JIRa

Question

Hi

I want to know which database table holds the information on which users are member of which groups.?

Pilar

Taha Khanzada · Answer

Hi Pilar,

To get Group membership details you can use table called cwd_membership

To get user belongs to which all groups

Select * from cwd_membership where child_name = 'user_name'

To get list of users in particular groups

select USER_NAME, DISPLAY_NAME, EMAIL_ADDRESS from cwd_user 
where lower_user_name in (select child_name from cwd_membership where parent_name = 'group_name')

Taha