Lost admin rigths ('administrator' is not showing when login as admin)

juan.jose · October 17, 2019, 9:52pm

When i login as administrator im not able to see tab ‘administrator’ in order to make other users admin:

I tried solution mentioned here, but still not able to see the ‘administrator’ tab:

Im using community version 7.8 (build 26217)

Thanks

ganncamp · October 18, 2019, 3:11pm

Hi,

Welcome to the community!

In fact the query published in the docs is out of date (and will be fixed at the next release).

Try this:

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'));

Ann

juan.jose · October 18, 2019, 5:27pm

Thanks for your solution Ann, is working now.

keixer_soze1 · October 27, 2020, 9:15pm

This does not work for me. I do not see an id column in my users table. Also the problem I see is that when I login, it correctly reads user login and password (because if I put the wrong one it it fails) but I get no user logged in in main bar and I see login button again. I’m running the latest community edition but started in 7.9.1.

My user_roles tables is empty.

ganncamp · October 28, 2020, 3:22pm

Hi @keixer_soze1,

Welcome to the community!

Since this thread is a year old, please start a new one with full context. Feel free to reference this one.

Ann