where is stored the User Group Membership in database

[MM_10991077]

Hello Community,

I am trying to figure out where in database (MySql) is stored User Group Memberships for particular user account. 

I found table "acl_role" but this seems to be related to project only.

Goal is to create a query which link user_id with it's roles/memberships in Codebeamer.

thank you

[pshashipreetham]

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,

[MM_10991077]

Hello pshashipreetham,

unfortunately following tables does not exist in our MySQL database:
cb_user_group

cb_user_user_group