Can't Log In To JIRA - No Global Permission In Database

Still need help?

The Atlassian Community is here for you.

Ask the community

Platform notice: Server and Data Center only. This article only applies to Atlassian products on the Server and Data Center platforms.

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:

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 request

Cause

Global permissions table is empty. 

Resolution

  1. Check the GlobalPermissions

    select * from globalpermissionentry;
  2. If any of the below is missing, we need to update the table

      id   |  permission  |      group_id
    -------+--------------+---------------------
     10000 | ADMINISTER   | jira-administrators
     10001 | USE          | jira-users
     10006 | SYSTEM_ADMIN | jira-administrators
  3. To update run the below queries:

     insert into globalpermissionentry values (10000,'ADMINISTER','jira-administrators');
     insert into globalpermissionentry values (10001,'USE','jira-users');
     insert into globalpermissionentry values (10006,'SYSTEM_ADMIN','jira-administrators');
    tip/resting Created with Sketch.

    Please backup JIRA before proceed to run the SQL queries here.

  4. Restart JIRA





Last modified on Nov 14, 2018

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.