12 Jan’18

Dynamics 365, EnterpriseIdentify Users having specific privileges

Introduction:

This blog consists of information on how you can find the users having specific privileges and in which role they have the privileges.

Solution:

Make use of the below Fetch XML to identify who has access to prvReadAccount related to his Role.

The fetch can be performed on System User level or for teams.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >

<entity name="privilege" >

<attribute name="name" />

<link-entity name="roleprivileges" from="privilegeid" to="privilegeid" alias="pu" link-type="inner" >

<link-entity name="role" from="roleid" to="roleid" alias="rpu" link-type="inner" >

<attribute name="name" />

<link-entity name="systemuserroles" from="roleid" to="roleid" alias="sr" link-type="inner" >

<link-entity name="systemuser" from="systemuserid" to="systemuserid" alias="srr" link-type="inner" >

<attribute name="systemuserid" />

<attribute name="fullname" />

</link-entity>

</link-entity>

</link-entity>

</link-entity>

<filter type="and" >

<condition attribute="name" operator="eq" value="prvReadAccount" />

</filter>

</entity>

</fetch>

Response:

SystemUserResponse

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >

<entity name="privilege" >

<attribute name="name" />

<link-entity name="roleprivileges" from="privilegeid" to="privilegeid" alias="pt" link-type="inner" >

<link-entity name="role" from="roleid" to="roleid" alias="rpt" link-type="inner" >

<attribute name="name" />

<link-entity name="teamroles" from="roleid" to="roleid" alias="tr" link-type="inner" >

<link-entity name="team" from="teamid" to="teamid" alias="trr" link-type="inner" >

<attribute name="teamid" />

<attribute name="name" />

</link-entity>

</link-entity>

</link-entity>

</link-entity>

<filter type="and" >

<condition attribute="name" operator="eq" value="prvReadAccount" />

</filter>

</entity>

</fetch>

TeamResponse

Written by

Krishna Bhanushali

Software Developer

Leave a Reply

Your email address will not be published. Required fields are marked *

Time limit is exhausted. Please reload the CAPTCHA.

Want to streamline your business processes?

  • This field is for validation purposes and should be left unchanged.

Recent Articles

  • Design Views in App Designer – D365

    11 April’ 2018

    Introduction: Create and edit public or system views by using the app designer Description: Dynamics 365 sales app des...

    Read more
  • Call Management in D365 Field Service

    10 April’ 2018

    Introduction: This blog provides a solution to requirement of Client for Call Management in D365 Field Service. Scenari...

    Read more
  • Fetch Hierarchical data for Product Category in Dynamics 365 Operations

    10 April’ 2018

    Introduction: In this blog article, we will see how we can fetch hierarchical data using X++. How to fetch? We will ta...

    Read more
  • PowerBI April 2018 Update: Combo Chart Line Formatting

    10 April’ 2018

    Introduction: PowerBI introduced the feature to format line styles and legends for line charts a while ago. However, th...

    Read more
  • Power BI April 2018 Update: Q&A Explorer

    10 April’ 2018

    Introduction: In this blog we will explore some of the new features added to Power BI. Power BI has upgraded its Q&...

    Read more