What Grafana version and what operating system are you using?
CentOS Linux
What are you trying to achieve?
Get full admin rights with the local admin account
How are you trying to achieve it?
By logging in as the admin user
What happened?
When trying to delete other orgs, I’m getting:
You'll need additional permissions to perform this action. Permissions needed: orgs:delete
What did you expect to happen?
I expect to be able to do everything that the admin user should be able to do
So it looks like my local admin user lost its superuser ability after upgrading to 11.2.0 and maybe before that – it’s just that i’ve needed the admin user for a while. But what’s happening now is that I can’t for example delete an org (see message above).
The user has the Admin role. Has anyone run into this?
It says it’s a Grafana admin. But it’s assigned to only one org now. If I try to add it to another org, I get an error saying I don’t have enough privileges:
You'll need additional permissions to perform this action. Permissions needed: org.users:add
Interesting, there was a thread from the Grafana team I came across that talked about a change that seems to be related to this. I will try to find it.
This is a dev instance of grafana, I could potentially just wipe and start from scratch. But would like to avoid that if possible. I like the sqlite idea. I will try that and report back. This may take a while though
==================================
Quick update in case someone runs into this. The solution was to insert the missing records into the org_user table. In my case it was:
INSERT INTO org_user VALUES(nextval('org_user_id_seq'::regclass), <YOUR_ORG_ID>, <ADMIN_USER_ID>, 'Admin', CURRENT_TIMESTAMP, CURRENT_TIMESTAMP);
Once that was done, everything started working again.
