need to create account in Jira via SQL in jira internal directory

[chandrakanth prasadam]

I need the SQL query to create new test account via SQL query in Jira internal directory.

[Nic Brough -Adaptavist-]

Do not do this, you WILL break your Jira.

Also, it's going to take you several hours - you need to take your Jira offline, take a full backup of the database, prove that you can restore a working Jira from it, run your SQL, restart Jira, re-index it, and then test your changes have worked in many places before letting your users back in.

Also, you should not have damaged your Crowd database with SQL either - you are almost certainly going to run into problems with this quite soon.

[Mohamed Benziane]

Hi,

Use the REST API is the most secure option. Why do you need to create an account using sql ?

[chandrakanth prasadam]

How to use the Rest api any document -

we facing some issues whiile creating the account manually, recently we have updated the CWD DB in lower env with encryption the user names.

Why to use Rest api ? what happens fi we use the create query viadb

[Mohamed Benziane]

here the doc: https://docs.atlassian.com/software/jira/docs/api/REST/9.7.2/#api/2/user-createUser

When using the sql to create or update Jira you will need to update several table and you might break you instance.