Solve the Mystery of User Permissions đĩī¸
Ever been asked, "Why can Sarah see this record, but John can't?" or "Why does User A have more privileges than User B?" Manually comparing security roles across users is tedious, error-prone, and time-consuming.
The Effective Permissions Comparator simplifies this entire process. Select two users and instantly see a detailed, side-by-side comparison of their effective permissions for every table and privilege in the system. It pinpoints every difference, saving you hours of troubleshooting.
Key Features
Detailed Comparison
Compares the effective permissions for Create, Read, Write, Delete, Append, Append To, Assign, and Share on all standard and custom tables.
Highlight Differences
Mismatched permissions are instantly highlighted in red, so you can spot the differences without effort.
Identify the Source Role
Hover over any permission to see a detailed tooltip showing the privilege depth (User, BU, etc.) and the exact security role that grants it for each user.
Includes Team Roles
The comparison accurately calculates the users' effective permissions by including roles inherited from all the teams they are members of.
Miscellaneous Privileges
Includes a dedicated tab to compare non-table-specific permissions, such as 'Bulk Edit', 'Export to Excel', and 'Go Offline'.
Powerful Filtering & Search
Filter the entire view to show only mismatches with a single click, and use the search bar to quickly find a specific table.
How It Works
- Connect: Open XrmToolBox and connect to your Dataverse environment.
- Select Users: Choose the two users you want to compare from the 'User A' and 'User B' dropdown lists. The tool will load their assigned security roles.
- Compare: Click the "Compare Permissions" button.
- Analyze Results: Browse the tabs to view the comparison. Mismatches are highlighted, and hovering provides deep insights into the source of each permission.
Why You Need This Tool
- Troubleshooting Access: Quickly resolve user access issues by seeing exactly where their permissions differ.
- Security Audits: Easily audit and validate that users have the correct level of access according to their job function.
- Onboarding/Offboarding: Ensure a new user has the same permissions as their counterpart, or verify a user's access has been properly modified.
- Role Consolidation: Identify redundant or conflicting roles by analyzing the permissions of users who should be similar.
Get The Tool
The Effective Permissions Comparator is available for free in the XrmToolBox Plugin Store. Simply open XrmToolBox, navigate to the Plugin Store, and search for "Effective Permissions Comparator" to install it.
Open in XrmToolBox Plugin Store