Hi All,
environment : D365Fo
Requirement Need to create SSRS report in that need to show all Privilege and its depend duty and role.
I found the three system table to get the record but there is no relation between them. Please help to achieve this task
SecurityRole role;
SecurityDuty duty;
SecurityPrivilege Privilege;
Hi Tony, I hope you are doing good.
You can create and edit relationships between entities as your business needs. Here you can find info of how doing that:
Create and edit entity relationships with Dynamics 365 Customer Engagement (on-premises) | Microsoft Docs
I strongly recommend create a solution to save those changes into a container and all personalization are just managed there. Here more info of how to build a solution:
Create a solution (Dynamics 365 Customer Engagement on-premises) | Microsoft Docs
Here additional of creating a report in Dynamics AX:
Reporting in Microsoft Dynamics AX | Microsoft Docs
If this answers your question, please check it as verified to help others finding useful information.
Welcome to this amazing community.
Hi Tony,
you can try to check SystemSecurity* data entities in AOT. For example SystemSecurityDutyV2Entity seems to contain privileges, duties and roles.
The data entity mentioned by Nikolaos could be used, but will return a huge number of records. The hierarchy is not stored in tables, but is part of the meta data. The entity, but also the form Security configuration is reading the meta data and present it in a certain way. If the entity is not sufficient for your needs, you can have a look at the form Security configuration and the related x++ coding to learn how to apply it for your report.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
CA Neeraj Kumar 2,188
André Arnaud de Cal... 868 Super User 2025 Season 2
Sohaib Cheema 593 User Group Leader
