View the role assigned to each user (Report Server)
Found My Answer from a Blog Almost similar :) !!!

DECLARE @UserName VARCHAR(200) = 'UserName' 

SELECT Rol.RoleName,Us.UserName ,Cat.PATH,Cat.[Name] ReportName,
CASE Cat.Type WHEN 1 THEN 'Folder' WHEN 2 THEN 'Report' 
WHEN 3 THEN 'Resource' WHEN 4 THEN 'Linked Report' 
WHEN 3 THEN 'Data Source' ELSE '' END AS CatalogType
,Cat.Description 
FROM Catalog Cat     --Parent
INNER JOIN Policies Pol 
ON Cat.PolicyID = Pol.PolicyID
INNER JOIN PolicyUserRole PUR 
ON Pol.PolicyID = PUR.PolicyID 
INNER JOIN Users Us 
ON PUR.UserID = Us.UserID 
INNER JOIN Roles Rol 
ON PUR.RoleID = Rol.RoleID
WHERE   Cat.Type in (1,2)
AND  ( Us.UserName LIKE @UserName  )
ORDER BY Cat.PATH