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