Hi
I want to know which database table holds the information on which users are member of which groups.?
Pilar
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.