Uploaded image for project: 'SonarQube'
  1. SonarQube
  2. SONAR-12595

Outdated "Reinstating Admin Access" query

    XMLWordPrintable

    Details

    • Type: Documentation
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 8.1
    • Component/s: None
    • Labels:
      None
    • Edition:
      Community
    • Production Notes:
      None

      Description

      The documentation on how to reinstall admin access from db is outdated, as the schema as changed.

      Previous query :

       INSERT INTO user_roles(user_id, role) VALUES ((select id from users where login='mylogin'), 'admin');

       

      Query that we need to use instead :

       INSERT INTO user_roles(user_id, role, organization_uuid) VALUES ((select id from users where login='mylogin'), admin', (select uuid from organizations where kee='default-organization'));

       

        Attachments

          Activity

            People

            Assignee:
            pierre.guillot Pierre Guillot
            Reporter:
            pierre.guillot Pierre Guillot
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Due:
              Created:
              Updated:
              Resolved: