Title: Reset Capabilities
Last modified: September 1, 2016

---

# Reset Capabilities

 *  Resolved [c05338](https://wordpress.org/support/users/c05338/)
 * (@c05338)
 * [9 years, 12 months ago](https://wordpress.org/support/topic/reset-capabilities-1/)
 * Hello,
 * I’ve unchecked certain capabilities from Administrator role which they were 159
   capabilities, now I can’t see the unchecked ones as if they’re removed and all
   I see is 131 capabilities sound like the other 28 have been deleted. How to restore
   them? And super admin capability has been removed from the recent updates so 
   the USER ID 1 can’t be the master admin of the site and rest are normal administrators.
 * [https://wordpress.org/plugins/advanced-access-manager/](https://wordpress.org/plugins/advanced-access-manager/)

Viewing 12 replies - 1 through 12 (of 12 total)

 *  [vasyl_m](https://wordpress.org/support/users/vasyl_m/)
 * (@vasyl_m)
 * [9 years, 11 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-7473598)
 * Hi **c05338**,
 * You have to be really careful with capabilities. Especially when you are working
   with Administrator capabilities. Ideally you should never uncheck any capabilities
   for Administrator role or user.
 * In order to restore your capabilities you would have to login to your database
   and find **wp_user_roles** option in your **wp_options** database table. Then
   simply replace the content of this options with following
 * a:6:{s:13:”administrator”;a:2:{s:4:”name”;s:13:”Administrator”;s:12:”capabilities”;
   a:74:{s:13:”switch_themes”;b:1;s:11:”edit_themes”;b:1;s:16:”activate_plugins”;
   b:1;s:12:”edit_plugins”;b:1;s:10:”edit_users”;b:1;s:10:”edit_files”;b:1;s:14:”
   manage_options”;b:1;s:17:”moderate_comments”;b:1;s:17:”manage_categories”;b:1;
   s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:6:”import”;b:1;s:15:”unfiltered_html”;
   b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;
   b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:8:”level_10″;
   b:1;s:7:”level_9″;b:1;s:7:”level_8″;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:
   7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;
   b:1;s:7:”level_0″;b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;
   b:1;s:13:”publish_pages”;b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;
   b:1;s:22:”delete_published_pages”;b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;
   b:1;s:22:”delete_published_posts”;b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;
   b:1;s:18:”read_private_posts”;b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;
   b:1;s:18:”read_private_pages”;b:1;s:12:”delete_users”;b:1;s:12:”create_users”;
   b:1;s:17:”unfiltered_upload”;b:1;s:14:”edit_dashboard”;b:1;s:14:”update_plugins”;
   b:1;s:14:”delete_plugins”;b:1;s:15:”install_plugins”;b:1;s:13:”update_themes”;
   b:1;s:14:”install_themes”;b:1;s:11:”update_core”;b:1;s:10:”list_users”;b:1;s:
   12:”remove_users”;b:1;s:13:”promote_users”;b:1;s:18:”edit_theme_options”;b:1;
   s:13:”delete_themes”;b:1;s:6:”export”;b:1;s:19:”show_screen_options”;b:1;s:14:”
   show_help_tabs”;b:1;s:14:”delete_comment”;b:1;s:15:”approve_comment”;b:1;s:12:”
   edit_comment”;b:1;s:18:”quick_edit_comment”;b:1;s:12:”spam_comment”;b:1;s:13:”
   reply_comment”;b:1;s:13:”trash_comment”;b:1;s:17:”unapprove_comment”;b:1;s:15:”
   untrash_comment”;b:1;s:14:”unspam_comment”;b:1;s:9:”customize”;b:1;}}s:6:”editor”;
   a:2:{s:4:”name”;s:6:”Editor”;s:12:”capabilities”;a:34:{s:17:”moderate_comments”;
   b:1;s:17:”manage_categories”;b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;
   b:1;s:15:”unfiltered_html”;b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;
   b:1;s:20:”edit_published_posts”;b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;
   b:1;s:4:”read”;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:7:”level_5″;b:1;s:7:”
   level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;
   b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;b:1;s:13:”publish_pages”;
   b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;b:1;s:22:”delete_published_pages”;
   b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;b:1;s:22:”delete_published_posts”;
   b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;b:1;s:18:”read_private_posts”;
   b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;b:1;s:18:”read_private_pages”;
   b:1;}}s:6:”author”;a:2:{s:4:”name”;s:6:”Author”;s:12:”capabilities”;a:10:{s:12:”
   upload_files”;b:1;s:10:”edit_posts”;b:1;s:20:”edit_published_posts”;b:1;s:13:”
   publish_posts”;b:1;s:4:”read”;b:1;s:7:”level_2″;b:1;s:7:”level_1″;b:1;s:7:”level_0″;
   b:1;s:12:”delete_posts”;b:1;s:22:”delete_published_posts”;b:1;}}s:11:”contributor”;
   a:2:{s:4:”name”;s:11:”Contributor”;s:12:”capabilities”;a:5:{s:10:”edit_posts”;
   b:1;s:4:”read”;b:1;s:7:”level_1″;b:1;s:7:”level_0″;b:1;s:12:”delete_posts”;b:
   1;}}s:10:”subscriber”;a:2:{s:4:”name”;s:10:”Subscriber”;s:12:”capabilities”;a:
   2:{s:4:”read”;b:1;s:7:”level_0″;b:1;}}s:7:”manager”;a:2:{s:4:”name”;s:7:”Manager”;
   s:12:”capabilities”;a:72:{s:13:”switch_themes”;b:1;s:11:”edit_themes”;b:1;s:16:”
   activate_plugins”;b:1;s:12:”edit_plugins”;b:1;s:10:”edit_users”;b:1;s:10:”edit_files”;
   b:1;s:14:”manage_options”;b:1;s:17:”moderate_comments”;b:1;s:17:”manage_categories”;
   b:1;s:12:”manage_links”;b:1;s:12:”upload_files”;b:1;s:6:”import”;b:1;s:15:”unfiltered_html”;
   b:1;s:10:”edit_posts”;b:1;s:17:”edit_others_posts”;b:1;s:20:”edit_published_posts”;
   b:1;s:13:”publish_posts”;b:1;s:10:”edit_pages”;b:1;s:4:”read”;b:1;s:8:”level_10″;
   b:1;s:7:”level_9″;b:1;s:7:”level_8″;b:1;s:7:”level_7″;b:1;s:7:”level_6″;b:1;s:
   7:”level_5″;b:1;s:7:”level_4″;b:1;s:7:”level_3″;b:1;s:7:”level_2″;b:1;s:7:”level_1″;
   b:1;s:7:”level_0″;b:1;s:17:”edit_others_pages”;b:1;s:20:”edit_published_pages”;
   b:1;s:13:”publish_pages”;b:1;s:12:”delete_pages”;b:1;s:19:”delete_others_pages”;
   b:1;s:22:”delete_published_pages”;b:1;s:12:”delete_posts”;b:1;s:19:”delete_others_posts”;
   b:1;s:22:”delete_published_posts”;b:1;s:20:”delete_private_posts”;b:1;s:18:”edit_private_posts”;
   b:1;s:18:”read_private_posts”;b:1;s:20:”delete_private_pages”;b:1;s:18:”edit_private_pages”;
   b:1;s:18:”read_private_pages”;b:1;s:12:”delete_users”;b:1;s:12:”create_users”;
   b:1;s:17:”unfiltered_upload”;b:1;s:14:”edit_dashboard”;b:1;s:14:”update_plugins”;
   b:1;s:14:”delete_plugins”;b:1;s:15:”install_plugins”;b:1;s:13:”update_themes”;
   b:1;s:14:”install_themes”;b:1;s:11:”update_core”;b:1;s:10:”list_users”;b:1;s:
   12:”remove_users”;b:1;s:13:”promote_users”;b:1;s:13:”delete_themes”;b:1;s:6:”
   export”;b:1;s:19:”show_screen_options”;b:1;s:14:”show_help_tabs”;b:1;s:14:”delete_comment”;
   b:1;s:15:”approve_comment”;b:1;s:12:”edit_comment”;b:1;s:18:”quick_edit_comment”;
   b:1;s:12:”spam_comment”;b:1;s:13:”reply_comment”;b:1;s:13:”trash_comment”;b:1;
   s:17:”unapprove_comment”;b:1;s:15:”untrash_comment”;b:1;s:14:”unspam_comment”;
   b:1;}}}
 * Regards,
    Vasyl
 *  [steveread](https://wordpress.org/support/users/steveread/)
 * (@steveread)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-7473632)
 * Hi,
 * I am having the same issue. I have made these changes, and the administrator 
   role is still locked.
 * Thanks for any ideas.
 *  [vasyl_m](https://wordpress.org/support/users/vasyl_m/)
 * (@vasyl_m)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-7473633)
 * Hi **steveread**,
 * Try to go to **usermeta** table and remove all settings that start with **aam_**
   prefix. You might restricted your admin dashboard menu.
 * Regards,
    Vasyl
 *  [steveread](https://wordpress.org/support/users/steveread/)
 * (@steveread)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-7473634)
 * I have settings for my username:
 * Also, “newadmin” was my attempt to create a new role. It didn’t work 🙁
 * (700, 46, ‘nickname’, ‘steveread’),
    (701, 46, ‘first_name’, ”), (702, 46, ‘last_name’,”),(
   703, 46, ‘description’, ”), (704, 46, ‘rich_editing’, ‘true’), (705, 46, ‘comment_shortcuts’,‘
   false’), (706, 46, ‘admin_color’, ‘fresh’), (707, 46, ‘use_ssl’, ‘0’), (708, 
   46, ‘show_admin_bar_front’, ‘true’), (709, 46, ‘wp_capabilities’, ‘a:1:{s:8:”
   newadmin”;b:1;}’), (710, 46, ‘wp_user_level’, ’10’), (711, 46, ‘dismissed_wp_pointers’,”),(
   712, 1, ‘wp_aam_cache’, ‘a:4:{s:38:”aam-post-access-roleadministrator|4418″;b:
   0;s:26:”aam-post-access-user1|4418″;b:0;s:38:”aam-post-access-roleadministrator
   |1841″;b:0;s:26:”aam-post-access-user1|1841″;b:0;}’),
 * I have many entries in wp_options (obviously). What am I looking for there?
 * I don’t have access to phpadmin; the systems guy gives me the sql, I edit, and
   he runs it.
 * Thanks again.
 *  [vasyl_m](https://wordpress.org/support/users/vasyl_m/)
 * (@vasyl_m)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-7473635)
 * **steveread**,
 * Ok. You might forward me your SQL dump (use [vasyl@vasyltech.com](https://wordpress.org/support/topic/reset-capabilities-1/vasyl@vasyltech.com?output_format=md)).
 * Please clarify what do you mean under “my admin is still locked”. What exactly
   is not working for you?
 * Regards,
    Vasyl
 *  [steveread](https://wordpress.org/support/users/steveread/)
 * (@steveread)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-7473636)
 * I can’t get to wp-admin or wp-users (access denied).
 * I can’t add a user.
 * In the User/Role Panel, the trashcan icon is greyed out, and the wait icon spins
   indefinitely
 * If I deactivate AAM, I have access again, but of course I don’t have the functionality.
 * I will send the SQL dump separately.
 * Thanks.
 *  [vasyl_m](https://wordpress.org/support/users/vasyl_m/)
 * (@vasyl_m)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-7473637)
 * **steveread**,
 * Sorry I’m confused. You’ve sad that you **do not** have access to wp-admin but
   at the same time you have access to AAM page (because you’ve mentioned about 
   greyed out buttons, spin etc).
 * Can you send me your admin credentials so I can see what is your problem?
 * Regards,
    Vasyl
 *  [steveread](https://wordpress.org/support/users/steveread/)
 * (@steveread)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-7473638)
 * When I go to the path exede-api.com/wp-admin (or wp-users), I get “access denied”
 * When I hit the AAM icon in the sidebar, that’s when I get the greyed out icons
   and the loading spinner.
 * I can’t give you access to the site; my company locks it down with white-listed
   IPs etc.
 * Thanks.
 *  [steveread](https://wordpress.org/support/users/steveread/)
 * (@steveread)
 * [9 years, 10 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-7473641)
 * Were you able to look at the SQL dump?
 * Thanks
 *  [steveread](https://wordpress.org/support/users/steveread/)
 * (@steveread)
 * [9 years, 9 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-7473649)
 * I guess not. I’ll try to fix it myself.
 *  [patriziolubrani](https://wordpress.org/support/users/patriziolubrani/)
 * (@patriziolubrani)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-8308025)
 * Hello, :/ well, i have the same problem of steveread, if i deactivate AAM or 
   i delete the plugins from FileZilla so i can access. I get the greyed out icons
   and the loading spinner.
 * VasilTech support wrote to me: “Most likely you restricted access to your admin
   role to Dashboard menu.You would need to reset AAM settings manually. Go to database
   and delete all options that start with aam_ prefix in _options table.”
 * The problem as steveread, I do not find anywhere in the prefix aam_
    and plugins
   is still installed, and still the charger continues to turn.
 *  [patriziolubrani](https://wordpress.org/support/users/patriziolubrani/)
 * (@patriziolubrani)
 * [9 years, 7 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-8308030)
 * Hello, in the database now i see option that start with aam_ prefix in _options
   table.”
    I had seen that there were many more hidden pages, so I found seven 
   options with the prefix aam_ I will try to delete it. I will write later if i
   will have problem. :/ anyway Thank You
    -  This reply was modified 9 years, 7 months ago by [patriziolubrani](https://wordpress.org/support/users/patriziolubrani/).
      Reason: charged two time, i want delete it
    -  This reply was modified 9 years, 7 months ago by [patriziolubrani](https://wordpress.org/support/users/patriziolubrani/).
      Reason: confirm

Viewing 12 replies - 1 through 12 (of 12 total)

The topic ‘Reset Capabilities’ is closed to new replies.

 * ![](https://ps.w.org/advanced-access-manager/assets/icon-256x256.png?rev=3447421)
 * [Advanced Access Manager – Access Governance for WordPress](https://wordpress.org/plugins/advanced-access-manager/)
 * [Support Threads](https://wordpress.org/support/plugin/advanced-access-manager/)
 * [Active Topics](https://wordpress.org/support/plugin/advanced-access-manager/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/advanced-access-manager/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/advanced-access-manager/reviews/)

## Tags

 * [aam](https://wordpress.org/support/topic-tag/aam/)

 * 12 replies
 * 4 participants
 * Last reply from: [patriziolubrani](https://wordpress.org/support/users/patriziolubrani/)
 * Last activity: [9 years, 7 months ago](https://wordpress.org/support/topic/reset-capabilities-1/#post-8308030)
 * Status: resolved