0

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

Improve this question
3
  • 1
    You added those permissions to your own admin user or did you created another user? Commented Feb 27, 2015 at 14:52
  • no, by mistake only own admin itself.... Commented Feb 27, 2015 at 14:52
  • I just add the link on how to reset roles templatemonster.com/help/… Commented Mar 4, 2021 at 15:31

2 Answers 2

Reset to default
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.

Improve this answer
4
  • hi, thanks.... instead of running queries, can you please help me to do manually? Commented Feb 27, 2015 at 15:08
  • please see the image in the question and help me.... Commented 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. Commented 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. Commented Feb 27, 2015 at 16:02
1

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

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.