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

CC BY-SA 3.0
2015-04-27T16:33:30.493Z
2015-04-27T16:33:30.493Z
dauble
<p>'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 <code>craft_users</code> table should be sufficient to restore privileges, without clearing out the other tables.</p>

<p>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.</p>

CC BY-SA 3.0
2015-04-27T17:51:41.673Z
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
CC BY-SA 3.0
2015-04-27T17:07:07.517Z
2015-04-27T17:07:07.517Z
Douglas McDonald
<p>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.</p>

<p>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?</p>

<users>
CP Gear Icon missing? Created new Super Admin account
# CP Gear Icon missing? Created new Super Admin account

(Asked by: username_0 on 2015-04-27)

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?

**Tags:** users


---

## 2 answers

### Answer by username_1 on 2015-04-27. Score: 4 | Accepted answer

'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.

> **Comments:**
> **username_0**: 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!  

---

### Answer by username_0 on 2015-04-27. Score: 1

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.


---

