Tag Archives: security

SQL Security Roles information

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

Posted in Helpers, SQL | Tagged , , | Leave a comment