nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how can I add user to jira group using sql server ?

Marine Tm

Hello,

is there a way to add or delete user into a Jira group using sql server ? if yes how please ?

Thank you !

Accepted answers

Nic Brough -Adaptavist-

Yes, you can do this, but you REALLY do not want to do it this way.

The process is

Stop Jira
Take a full backup
Restore the backup to a test server to make sure it is valid
Run the SQL against the database and hope it is valid (there's more than one table you'll need to update - do you know which ones you need to touch and how to do it right?)
Restart Jira
Run a full locking re-index of the entire system

Are you really sure this is the best option? When you could do it perfectly safely and without taking anything offline via the UI, or REST?

All comments

Jonas Ekström

Hi,

Is it possible to insert straight into the database? Yes, it's always possible to add data into a database. I'd personally advice against it.
If changes are to be made programatically I'd do it via REST API instead of straight into a database.

https://docs.atlassian.com/software/jira/docs/api/REST/7.6.1/#api/2/user
https://docs.atlassian.com/software/jira/docs/api/REST/7.6.1/#api/2/group

Nic Brough -Adaptavist-

Yes, you can do this, but you REALLY do not want to do it this way.

The process is

Stop Jira
Take a full backup
Restore the backup to a test server to make sure it is valid
Run the SQL against the database and hope it is valid (there's more than one table you'll need to update - do you know which ones you need to touch and how to do it right?)
Restart Jira
Run a full locking re-index of the entire system