I've built my own access points of sorts using ASP.
Basics of the site are:
- Home screen that displays all reports you have requested.
- Profile page to request access to new reports. Before reports become active for you, the site will email a chosen Approver, who must visit the site and give it the OK.
- User Management page that gives admins an easy way to search for users and modify their access.
- Report Management for admins. Allows for new reports to be added. Only info needed is the location of the report on the server (MyReports/Report1.qvw), and who the approvers are. Can also take reports offline from here
Each report has section access that pulls information from the same tables the site uses for its user information, so as soon as a user gains access to a report, that information is available to the report. Setting the reports to use a binary load, with just the section access in the front end and 15 minute updates allows for swift access to reports.
The benefits of this are:
- Users only see reports they have access to.
- Users must seek approval to access a report.
- New reports can be easily added to a large group of users.
- There is no login needed, as users are authenticated using their windows identity.