Tag Archives: role

Here is an SQL to retrieve all security roles privileges for all entities to help with comparing or to be used in an SSRS report SELECT FilteredRole.name as UserName, EntityView.PhysicalName, EntityView.OriginalLocalizedName as DisplayName, Privilege.Name as PrivilegeName, AccessLevel = CASE Privilege.AccessRight … Continue reading →