Regarding sonarqube admin Privileges - Lost admin rights for default account

authentication
sonarqube
administration

(Test) #1

Hi,

Good Evening. Hope you are doing great.

We are running into an issue regarding sonarqube community edition default admin account privileges. Somehow the system is not allowing to perform admin access rights for default account and unable to perform any admin level function. Like unable to add any user/group etc.,.

resetting admin password also didn’t help…


(G Ann Campbell) #2

Hi,

The docs address this:

If you’ve deleted admin and subsequently locked out the other users with global administrative permissions, you’ll need to re-grant admin to a user with the following query:

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

 
Ann