Monday, April 4, 2011

SQL Reporting Services security report

The following query retrieves SQL Reporting Services security settings:

SELECTC.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