News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Find list of roles, a ...

Microsoft Dynamics AX (Archived)

Find list of roles, a duty is mapped to.

(0) Share

Report

Report

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

All responses Img

All responses (3)

Answers Img

Answers (3)

Verified answer

André Arnaud de Cal... 291,391 Super User 2024 Season 2 on at

Like (0)

Report

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 316 on at

Like (0)

Report
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 230,445 Most Valuable Professional on at

Like (0)

Report

RE: Find list of roles, a duty is mapped to.

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

Helpful resources

Quick Links

Leaderboard

#1

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

#2

Martin Dráb 230,445 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans