I have two environment of my website using Magento 2.2.1 One is dev and another is staging.

I have created ACL Roles and assign them to users.

Now i want to copy these ACL Roles to staging environment.

I have exported 4 tables:

admin_user, admin_passwords, authorization_role, authorization_rule

and import into staging db.

But am facing issue while doing setup:upgrade.

Issue is:

We can't find the role for the user you wanted

Any help will be appreciated.


Your approach is flawed.

All you have to do is:

  1. deploy the corresponding acl.xml files to staging and execute
  2. php bin/magento setup:upgrade
  • I did that but am facing issue in Magento_Integration module: We can't find the role for the user you wanted – Rajbir Singh Jan 17 '18 at 17:30
  • Seems like there is more to this than the information that you provide. Restoring the db to a previous working state might also help. – vitoriodachef Jan 18 '18 at 8:26
  • After restoring db to previous version its working fine but ACL role are not there. – Rajbir Singh Jan 18 '18 at 11:55
  • Deploy code that contains your acl rules. Acl rules are added in acl.xml files. php bin/magento setup:upgrade php bin/magento setup:di:compile php bin/magento cache:clean Also the modules that hold your acl.xml files should be enabled for this to work. – vitoriodachef Jan 18 '18 at 13:43

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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