Report on security roles

(0) Share

Report

Posted on by Vighnesh

1,942

Hi All,

I am trying to build a report in Power BI on roles assigned to a Dynamics CRM user- detailed report on privileges and access levels too. Can anyone help me in figuring out the right tables that I should query?

And what happens in the database when a role is associated/disassociated? What table are updated?

*This post is locked for comments

All responses (1)

Answers (1)

Verified answer

Alex Fun Wei Jie 33,626 on at

Like (0)

Report

RE: Report on security roles

Hi,

For security role part, you can refer to below links.

FetchXML

- you have to modify a little bit.

[View:https://community.dynamics.com/crm/b/crmmitchmilam/archive/2010/07/20/creating-a-query-to-find-all-users-with-a-specified-security-role:750:50]

SQL

[View:https://community.dynamics.com/crm/b/manojbatchumicrosoftdynamicscrmblog/archive/2015/09/15/crm-and-sql-tip-01-how-to-find-out-the-security-roles-assigned-to-the-user:750:50]

For security privilege access level

Fetchxml

- you have to modify a little bit.

[View:https://community.dynamics.com/crm/f/117/t/261195:750:50]

SQL

[View:https://dynamics365blocks.wordpress.com/2017/10/30/how-to-get-security-privileges-in-excel-format-in-ms-crm/:750:50]