Posting in the Magento forums has been disabled pending the implementation of a new and improved forum solution which should better serve the community.
For new questions please post at magento.stackexchange.com, the community-run support site for the Magento community. We will be providing updates on the new forum solution soon. For questions or concerns please email email@example.com.
How to reset Admin role and permissions to all in Backend???
I think you are talking about accidental removing privileges for your self on the magento backend. Permissions for backend users are stored in the admin_rule table. Make a backup of the table before trying any of this! You should be able to safely delete all entries with in this table (SQL: truncate admin_rule;) then repopulate it giving full access to all users (SQL: insert into admin_rule (role_id,resource_id, role_type, permission) SELECT role_id, ‘all’ AS resource_id, ‘G’ AS role_type, ‘allow’ AS permission FROM admin_role). This should work… in theory.