Skip to main content

Notifications

Announcements

Join us in the Community for an AMA: December 12th Register Today
Announcing Mentions and Quick Responses!
News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / Find list of roles, a ...
Microsoft Dynamics AX (Archived)

Find list of roles, a duty is mapped to.

(0) ShareShare
ReportReport
Posted on by NoobDaxCoder

Is there a way to find out all the roles a duty is mapped to?  Without manually checking each every single role for the duty.

*This post is locked for comments

  • Verified answer
    André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 291,113 Super User 2024 Season 2 on at
    RE: Find list of roles, a duty is mapped to.

    Hi NoobDaxCoder,

    You can also open the Security privileges form (System administration > Setup > Security) and select the desired duty. Then in the fact boxes you will see which roles this duty is in.

  • Verified answer
    AdnDalhi Profile Picture
    AdnDalhi 316 on at
    RE: Find list of roles, a duty is mapped to.

    You can create a quick SQL Query by using the following tables.

    • SecurityRole: Contains list of roles
    • SecurityUserRole : Contains the user to role mappings 
    • SecurityTask: Contains the list of duties and privileges
    • SecuritySubTask: Contains the duty to privilege mappings
    • SecurityRoleTaskGrant: contains the list of role to duty mapping
  • Verified answer
    Martin Dráb Profile Picture
    Martin Dráb 229,918 Most Valuable Professional on at
    RE: Find list of roles, a duty is mapped to.

    Yes, it is: How to: Find Objects and Roles Related to Security Constructs.

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.

Helpful resources

News and Announcements

Join us in the Community for an AMA: December 12th Register Today
Announcing Mentions and Quick Responses!

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Complete!

🔔 Be sure to subscribe to the new forums you are interested in to stay up to date! 🔔

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,113 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 229,918 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans