where is stored the User Group Membership in database

In Codebeamer, user roles (i.e., User Group Memberships like System Administrator, Support User, etc.) are stored in the database but are not managed directly through theacl_role table — that table is primarily tied to project-level ACLs (Access Control Lists).

To query user group memberships (global roles), you need to join the following tables:

Key Tables:

• users – stores user account information

• cb_user_group – stores group definitions (e.g., "System Administrator", "Regular User")

• cb_user_user_group – mapping table linking users to user groups
  
  

SQL Query to Get User Group Memberships:

SELECT 
u.id AS user_id,
u.login_name,
g.name AS group_name
FROM 
users u
JOIN 
cb_user_user_group ug ON u.id = ug.user_id
JOIN 
cb_user_group g ON ug.user_group_id = g.id
WHERE 
u.login_name = 'your_user_login';

Notes:

• Replace 'your_user_login' With the actual login name.

• This will give all global user group memberships, as seen in the User Group Memberships section of the UI you shared.

• These roles determine what the user can access across the entire Codebeamer system, not specific projects.

If you need project-specific roles, then yes, you will also need to consider:

• project_memberships

• acl_role

• And associated linking tables.

Thanks,