Is there an alternate way to change the resources available to each user role? The "System" resource has been removed from the admin role, so alas, I can't access the role resource UI in order to restore these permissions. Any suggestions?

1 Answer 1


You have the table authorization_rule and permissions are in the column resource_id

Find the role_id you want to modify in the table authorization_role and do

UPDATE `m2_authorization_rule` SET `resource_id`='Magento_Backend::all', `permission` = 'allow' WHERE role_id = 'ROLE_ID_TO_MODIFY';

Your Answer

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

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