I am working on Report Builder 1.0 AdHoc Reporting tool and want to implement Security/ Entitlements on the Tables/ data that the users can access. I cannot use multiple logins. I have a table that has the UserID and the RegionID.
I want to restrict the users to data for only the region that they are entitled for and return the data to them through AdHoc Reporting. Anyway to build this security/ Entitlements is highly appreciated.