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?

[Alexey Matveev · Accepted solution]

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.

[Pumper1]

Thank you. Maybe you have some guides how to do it with REST?

[Alexey Matveev]

Kindly read the documentation I provided.

You should execute POST /rest/api/2/user with payload

{ "name": "charlie", "password": "abracadabra", "emailAddress": "charlie@atlassian.com", "displayName": "Charlie of Atlassian", "applicationKeys": [ "jira-core" ] }

That is all you should do.

[Pumper1]

Thank you