Security Roles Assigned to Users

(0) Share

Report

Posted on by Ryan Maclean

3,070

Hi all,

I was wondering if there was a way to find out which security roles are assigned to all users? I have inherited the current system in place at my workplace from a previous employee and the User permissions are a bit of a mess, so I would like to get an easy overview of all the security roles that are assigned to each user.

I have searched fruitlessly in trying to find this, but so far I havent been able to find an easy way to do this, so any help would be appreciated.

Ideally I would like to be able to make a matrix view of this, but at the moment I would settle for any way of viewing the information.

Thanks,

Ryan

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Community Member on at

Like (1)

Report

Hi Ryan,

Not sure if you're aware but MS CRM 2011/2013 comes with a "User Summary" report in the Report section that gives you all the users and their respective security roles.

Here is a post that shows more details: www.powerobjects.com/.../dynamics-crm-user-summary-report

Was this reply helpful? Yes No
Ryan Maclean 3,070 on at

Like (0)

Report

Hi Eric,

I feel a bit daft now, i don't know why I didnt realise this! Thank you for pointing it out to me.

Ryan

Was this reply helpful? Yes No
Suggested answer

moataz fararjeh 20 on at

Like (0)

Report

Find the below

SELECT

dbo.RoleBase.Name AS RoleName, dbo.SystemUserBase.FullName, dbo.TeamBase.Name AS TeamName

FROM

dbo.SystemUserBase INNER JOIN

dbo.SystemUserRoles ON dbo.SystemUserBase.SystemUserId = dbo.SystemUserRoles.SystemUserId INNER JOIN

dbo.RoleBase ON dbo.SystemUserRoles.RoleId = dbo.RoleBase.RoleId INNER JOIN dbo.TeamRoles ON dbo.RoleBase.RoleId = dbo.TeamRoles.RoleId INNER JOIN

dbo.TeamBase ON dbo.TeamRoles.TeamId = dbo.TeamBase.TeamId

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (0)

Report

Here's a URL to help you:

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

Hope you know that you can also check it in reports without using sql query: go to sales>>reports>> Run 'user summary'

Was this reply helpful? Yes No
Suggested answer

PS 23,577 on at

Like (0)

Report

Here's a URL to help you:

community.dynamics.com/.../crm-and-sql-tip-01-how-to-find-out-the-security-roles-assigned-to-the-user

Hope you know that you can also check it in reports without using sql query: go to sales>>reports>> Run 'user summary'

Was this reply helpful? Yes No