Sometimes we need that certain users have access only our shop to to view a report, create reports without having access to the rest of the private area of magento. In this tutorial I’ll show how to configure a user that has permissions only within the plugin sql2report.
Create the role
The first thing to do is create a role in magento, for that you are going to System -> Permissions-> Roles and give the button “Add New Role”. On the page that shows, you fill the role name ROLE_SQL2REPORT.
In the “Role Resources” section, you select only the sections
- Reports-> Sql2report : To view reports
- Reports->Sql2report Manager : To manage reports
Depending on the level of permissions you want, select either or both.
After configuring the new role, you create it by clicking on “Save Role”.
Create the user
Now you need to create a user who can view and configure reports to do this go to System-> Permissions-> Users and click the button “Add new user”.
In the information section, you fill with this parameters.
- User Name: sql2report
- First Name: User
- Last Name: Sql2report
- Email: sql2report@test.com
- Password: sql2report
In the roles section, you assign the role you just created ROLE_SQL2REPORT
Once the new user set, you create it by clicking on “Save user”.
Access with new user
Now if you access with the credentials of the new user, the menu will only have access to the Reports section and sub sections Sql2report and Sql2report Manager.
