jira server DATABASE add user into group with sql server

[Marine Tm]

hello,

how can i add a user into specific group jira using the database sql ?

is it by adding the use just into the cwd_membership ?

if yes how can i fill the columns ?

Please i need that just with sql, no rest api.

[Nic Brough -Adaptavist-]

This is a duplicate of https://community.atlassian.com/t5/Jira-Software-questions/jira-server-what-is-the-query-which-allows-to-add-user-into-jira/qaq-p/1765771 and https://community.atlassian.com/t5/Jira-Software-questions/how-can-I-add-user-to-jira-group-using-sql-server/qaq-p/1754147

Could you please stop asking the same question and follow the recommendations given when you've asked before?

[Tom Lister]

Hi @Marine Tm 

In theory you can add an entry to cwd_membership.

Using direct SQL is not recommended for many reasons such as support, reliability if API changes.

You will also need to ensure all the supporting fields in the table are correctly set.

A database change may not be immediately reflected in the Jira screen data.

Test it carefully in a staging server first.

Best

Tom