Monday, April 4, 2011

SQL Reporting Services security report

The following query retrieves SQL Reporting Services security settings:


SELECT   C.Path
        ,C.Name
        ,R.RoleName
        ,U.UserName
        FROM dbo.Users U
            ,dbo.PolicyUserRole PUR
            ,dbo.Roles R
            ,dbo.Policies P
            ,dbo.Catalog C
WHERE P.PolicyID = C.PolicyID
AND U.UserID = PUR.UserID
AND PUR.RoleID = R.RoleID
AND PUR.PolicyID = P.PolicyID

If you find this script useful please donate generously.

No comments:

Post a Comment