what is the name of the jira system storage user's table?

[zhaoyawei]

what is the name of the jira system storage user's table?

[Deleted user]

Hi @zhaoyawei,

cwd_user is the database table for storing JIRA data. Here is the data model link to Atlassian documentation.

Regards,

Priyanka

[zhaoyawei]

thanks,I want to the table that stores the user's password.

[Deleted user]

Hi @zhaoyawei,

The password is stored in CREDENTIAL column in cwd_user table.

Regards,

Priyanka

[zhaoyawei]

 cwd_user  stored  password is nopass ,how to get plaintext password?

[Deleted user]

Hi @zhaoyawei,

As the password is encrypted it's always recommended to reset the password to recover the user access as explained in this document.

Regards,

Priyanka

[Nic Brough -Adaptavist-]

To be clear, the password is not encrypted, it is salted and hashed.  It is not stored by Jira.

It is mathematically possible to get a plain text password back from a hash, but it's practically infeasible at the moment.