enter image description herei went to system > configuration > users .

i select "Administrators" and than "custom" than i selected some dashboard", newsletter and click on save.

now when i open admin panel with administrator, its showing only "dashboard" and "sales" and "system"

menu. please help me to find how to get back the other menus in admin panel.

enter image description here


2 Answers 2


You can run the following queries to reset it:

DELETE FROM admin_rule WHERE role_id = 1 AND resource_id != 'all';
UPDATE admin_rule SET permission = 'allow' WHERE role_id = 1;

This is assuming that the Administrator role_id is 1.

  • hi, thanks.... instead of running queries, can you please help me to do manually? Feb 27, 2015 at 15:08
  • please see the image in the question and help me.... Feb 27, 2015 at 15:12
  • 1
    This is what you need @BabyinMagento2. Copy the query and put it in your SQL tab in phpMyAdmin. Click run and that is it.
    – mbalparda
    Feb 27, 2015 at 15:13
  • You will need access to the database in order to do this. AFAIK, you cannot reset permissions using the Magento Admin only.
    – Laura
    Feb 27, 2015 at 16:02

In your database there are 4 tables regarding admin roles, users and rule. Open the table admin_role and from there you will be able to change the role the admin user have. My user looks like this:

enter image description here

  • hi, thanks a lot, i got that. what next i have to do to get all menus in admin panel. Feb 27, 2015 at 15:03
  • please see the image in the question and help me.... Feb 27, 2015 at 15:10

Your Answer

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

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