Sql-server – Does SSRS report user needs database level permission

To give a user rights to work with SSRS they need to have permissions at the root folder (which is what it sounds like you have done), but you also have to go into the "site settings" link into the "security" tab and add the user as (at minimum) a system user. It is easy to do one, but not the other. Both are required to allow full access to the system.

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