583862 - Access denied on /admin/models/ for an admin in zamboni

Status: VERIFIED FIXED

(addons.mozilla.org Graveyard :: Admin/Editor Tools, defect)

Description

[krupa raj[:krupa]]

Attachment: screenshot

Logging into https://next.addons.mozilla.org/z/en-US/admin/models/ with my admin account shows -

"Site administration

You don't have permission to edit anything."

Give me my power back!

Comment 1

[krupa raj[:krupa]]

I have this problem every time we do a DB refresh

Comment 2

[Jeff Balogh (:jbalogh)]

I don't. Are you an admin in prod?

Comment 3

[krupa raj[:krupa]]

(In reply to comment #2)
> I don't. Are you an admin in prod?

ya

Comment 4

[Andy McKay]

A script that bumped accounts who don't want admin access in prod, but do in preview would be good. I had to do myself and sancus yesterday.

Comment 5

[Wil Clouser [:clouserw]]

Alright, after future production dumps this is the SQL to run:

UPDATE groups SET rules="*:*" where name="QA" limit 1;
UPDATE auth_user SET is_superuser=1 WHERE id IN (SELECT user_id FROM groups_users JOIN groups ON groups.id = groups_users.group_id WHERE groups.name="QA");

To add users, we just add them to the "QA" group in production -- after they've verified that they have an excellent password.

Comment 6

[krupa raj[:krupa]]

This solved my problem. Thanks, clouserw!