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 permission

You first need to find out which group(s) have been granted the global permission.

The JIRA System Administrators global permission was added to JIRA in version 3.12. Anyone granted the JIRA System Administrators global permission can perform all administration tasks in JIRA, whereas anyone granted the JIRA Administrators global permission can perform most but not all administration tasks. Prior to version 3.12, anyone granted the JIRA Administrators global permission can perform all administration tasks.

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;
To find out which group(s) have been granted the JIRA System Administrators global permission, run the following database query:
select perm_parameter from schemepermissions where PERMISSION=44;
Now that you know which group(s) have the global permission, run the following database query to find out which users are in that group (replace "jira-administrators" with the group returned by the above query):
select child_name
from cwd_membership
where parent_name='jira-administrators'
If you don't know the password for the user(s) returned by this query, move on to Scenario B.

If there are no JIRA Administrators

If you're using Crowd or an external user management system, there may be no users with administrator permissions.
Find the groups in the external management system that you want to grant the administrator permissions and do the following:

  1. Shutdown JIRA.

  2. Use SQL to assign the appropriate group to the administrator permissions similar to this:
    update schemepermissions set perm_parameter='jira-system-administrators' where permission=44;
    update schemepermissions set perm_parameter='jira-administrators' where permission=0;
    update schemepermissions set perm_parameter='jira-users' where permission=1;



  3. Restart JIRA.

Scenario B: I know which user has the JIRA Administrators or JIRA System Administrators global permission, but I have forgotten the password

Here are two different ways you can solve this problem:

1. Send it via email

If 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 database

You 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