SELECT
distinct(C.Path),
U.UserName
FROM
Catalog C
INNER JOIN
PolicyUserRole
PUR
ON
C.PolicyID = PUR.PolicyID
INNER JOIN
Users U
ON
PUR.UserID = U.UserID
SELECT
distinct(C.Path),
U.UserName
FROM
Catalog C
INNER JOIN
PolicyUserRole
PUR
ON
C.PolicyID = PUR.PolicyID
INNER JOIN
Users U
ON
PUR.UserID = U.UserID where Path like '/POC/Farm Dashboard POC'
Thanks Kumar for the query...
ReplyDelete