Can't Log In To JIRA - No Global Permission In Database
Platform Notice: Data Center Only - This article only applies to Atlassian products on the Data Center platform.
Note that this KB was created for the Data Center version of the product. Data Center KBs for non-Data-Center-specific features may also work for Server versions of the product, however they have not been tested. Support for Server* products ended on February 15th 2024. If you are running a Server product, you can visit the Atlassian Server end of support announcement to review your migration options.
*Except Fisheye and Crucible
Problem
None of the users including Administrators can log in:
The following appears in the atlassian-jira.log:
1
2
3
4
5
6
2015-08-14 08:58:12,536 http-bio-6410-exec-24 anonymous 538x1508x1 1vkjf6z 10.60.2.104 /login.jsp The user 'user' is NOT AUTHORIZED to perform to login for this request
2015-08-14 08:58:12,536 http-bio-6410-exec-24 anonymous 538x1508x1 1vkjf6z 10.60.2.104 /login.jsp login : 'user' tried to login but they do not have USE permission or weren't found. Deleting remember me cookie.
2015-08-14 08:58:12,568 http-bio-6410-exec-24 anonymous 538x1508x1 1vkjf6z 10.60.2.104 /login.jsp The user 'user' is NOT AUTHORIZED to perform this request
2015-08-14 08:58:20,585 http-bio-6410-exec-24 anonymous 538x1509x1 1vkjf6z 10.60.2.104 /login.jsp The user 'user2' is NOT AUTHORIZED to perform to login for this request
2015-08-14 08:58:20,585 http-bio-6410-exec-24 anonymous 538x1509x1 1vkjf6z 10.60.2.104 /login.jsp login : 'user2' tried to login but they do not have USE permission or weren't found. Deleting remember me cookie.
2015-08-14 08:58:20,618 http-bio-6410-exec-24 anonymous 538x1509x1 1vkjf6z 10.60.2.104 /login.jsp The user 'user2' is NOT AUTHORIZED to perform this requestCause
Global permissions table is empty.
Resolution
Check the GlobalPermissions
1select * from globalpermissionentry;If any of the below is missing, we need to update the table
1 2 3 4 5id | permission | group_id -------+--------------+--------------------- 10000 | ADMINISTER | jira-administrators 10001 | USE | jira-users 10006 | SYSTEM_ADMIN | jira-administratorsTo update run the below queries:
1 2 3insert into globalpermissionentry values (10000,'ADMINISTER','jira-administrators'); insert into globalpermissionentry values (10001,'USE','jira-users'); insert into globalpermissionentry values (10006,'SYSTEM_ADMIN','jira-administrators');Please backup JIRA before proceed to run the SQL queries here.
Restart JIRA
Was this helpful?