Data source is based on MS SQL databases.
- Data is accessible through a data warehouse. Selected databases/tables are shipped to the DW SQL servers.
- We need to provide user authentication:
User logs into http://www.abc.com system
abc company has a complex access control system based on a hierarchy established by the product type such as:
Law Firm->Corporations
Enterprise->business units
Each of the above entities have users of different levels. Access control has to be enforced in cases such as in the Lawfirm edition a user from corporation A cannot access data for corporation B.
1) User clicks on the reporting portal link
2) User is taken to the reporting portal associated with their corporation. In there the user can run, edit, and add reports.
Please suggest any ideas .
Thanks in advance