Having a bit of an issue with user accounts. I created a new user account group (Super Admin) and assigned my user account to this group. Now that I've done that, I can no longer access the main settings area to edit file permissions, fields, sections, etc.

How can I reset my user account so I can access the settings? More importantly, how will I be able to add additional users with the same admin level as my user account?

2 Answers 2


'Admin' permission is set on the user level, whereas 'userGroup' permissions are set on the userGroup level. And as far as I know, 'admin' permission should trump any userGroup permissions. I'm not sure how you got locked out, unless you unchecked the 'Admin' checkbox on your user profile settings perhaps? Regardless, setting the 'admin' value to 1 in the craft_users table should be sufficient to restore privileges, without clearing out the other tables.

The only way to create other Admins is to check the 'Admin' checkbox on the user profile permissions tab. The next best thing is create a userGroup (called 'administrator' for example) with all of the permission boxes checked. Keep in mind however, that userGroup permissions need to be set explicitly, so if you create a new section, you may need to update the userGroup permissions to allow the new section.

  • Interesting. I had created two user groups, Super Admin and then another one called Admin. I wonder if Craft had just gotten confused with the two user groups. Thanks for the background info!
    – dauble
    Apr 27, 2015 at 17:51

I have a solution: I ended up clearing out all data in the craft_usergroups, craft_usergroups_users, craft_userpermissions, craft_userpermissions_usergroups, craft_userpermissions_users tables, then in craft_users, I reset the "Admin" field to "1" from "0" and this has solved my problem.


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.