In Dynamics 365 Finance and Operations, I need a report that lists every user and the permissions/privileges they have in full detail.
I already have the User and their assigned Roles report and the Role and the Users assigned to it report. What I need is a breakdown of every user's permissions/privileges
If this is only achievable by creating a Power BI report, how do I find the name of the needed tables to get the data I need?
Hi raghad,
What is it exactly what you need? A list with privileges or also more in detail the permissions for the entry points, entities and e.g. form control settings?
Hi,
There are several tables related to security,It depends on your business needs.You can refer to the following link to check the data entites about the security role.
docs.microsoft.com/.../systemsecurityuserroleassociationentity
André Arnaud de Cal...
291,971
Super User 2025 Season 1
Martin Dráb
230,846
Most Valuable Professional
nmaenpaa
101,156