Let's assume we use the default mysql command-line tool and MySQL as the backend database for Jira. If you are using a different database, you may need to change the following SQL statements accordingly:
- Connect to the Jira database with a client tool by running the mysql -u jirauser -p command, where jirauser is the username used by Jira to access the Jira database.
- You can find Jira's database details from the dbconfig.xml file located in JIRA_HOME.
- Change to the Jira database by running the use jiradb command, where jiradb is the name of Jira's database.
- Determine the groups that have the Jira System Administrator global permission with the following SQL statement:
select perm_parameter from schemepermissions where PERMISSION=44; ...