Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.
select distinct r.ReportID, r.ReportFileName, o.DisplayName, ra.RoleID, role.RoleName from dbo.AdvReport r join dbo.AoObject o on o.ObjectID = r.ReportID join vUserReportsAccess ur on r.ReportID = ur.ObjectID join dbo.AoRolePermission rp on r.ClassID = rp.ClassID join APX.ObjectRoleAccess ra on r.ReportID = ra.ObjectID --join dbo.vAoUserRoleAccess ura on ur.UserID = ura.UserID join AdvApp.vRole role on ra.RoleID = role.RoleID where o.IsAccessibleToAllRoles = 0 and r.ReportID in (89152,112356,18799)
Join the community of 500,000 technology professionals and ask your questions.
Connect with top rated Experts
19 Experts available now in Live!