JIRA 4.3 : Retrieving the JIRA Administrator
This page last changed on Mar 16, 2011 by mlassau.
On this page: Scenario A: I don't know which user has the JIRA Administrators or JIRA System Administrators global permissionYou first need to find out which group(s) have been granted the global permission.
To find out which group(s) have been granted the JIRA Administrators global permission, run the following database query: select perm_parameter from schemepermissions where PERMISSION=0; select perm_parameter from schemepermissions where PERMISSION=44; select child_name from cwd_membership where parent_name='jira-administrators' If there are no JIRA AdministratorsIf you're using Crowd or an external user management system, there may be no users with administrator permissions.
Scenario B: I know which user has the JIRA Administrators or JIRA System Administrators global permission, but I have forgotten the passwordHere are two different ways you can solve this problem: 1. Send it via emailIf you have configured JIRA to send email, just click on the Forgot Password link on the login page, enter your username and click the Send it to me button. Your password will be emailed to you. 2. Set the password directly in the databaseYou can also update the password hash stored for a user in your database. Run the following command to set the user called XXXX's password to the word sphere. update cwd_user set credential='uQieO/1CGMUIXXftw3ynrsaYLShI+GTcPS4LdUGWbIusFvHPfUzD7CZvms6yMMvA8I7FViHVEqr6Mj4pCLKAFQ==' where user_name='XXXX'; Then restart your JIRA instance. |
![]() |
Document generated by Confluence on Mar 27, 2011 18:51 |