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; } } }

create new user with sql query

Pumper1

hi,

I wont to create new users directly from database, how i can do it? maybe somebody have done sql query?

Accepted answers

Alexey Matveev

Do not do it. Use Rest Api instead.

https://docs.atlassian.com/software/jira/docs/api/REST/1000.1609.0/#api/2/user-createUser

All comments

Alexey Matveev

Do not do it. Use Rest Api instead.

https://docs.atlassian.com/software/jira/docs/api/REST/1000.1609.0/#api/2/user-createUser

Pumper1

Thanks for your answer, but can i do it with sql? I use Jira server

Alexey Matveev

You should not use SQL to modify any data in Jira. Your Jira will become unreliable and prone to errors and unexpected behaviour

Nic Brough -Adaptavist-

For SQL inserts:

Take your Jira service down.
Take a full backup of the database with your database tools.
Restore this on a test system to ensure it is valid.
Run the SQL to hit the 4-8 tables you need to amend/insert into
Restart Jira
Re-index it
Test every area of user interaction works for an old user and the new one
In 99.99% of cases, roll back the backup you took earlier because testing fails and you've found you've got a broken Jira.

But seriously, use REST.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

sql

jira

developer