Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » Tricks » Schema   (RSS)

How to create a 'company' security filter for a hosted application

Several customers have asked how to restrict data visibility in a report model for a hosted application, where every table has a "CompanyID" column, and every user that accesses the system is associated (via some other table) with exactly one company.

Collapsing a many-to-many relationship in a report model

Often a many-to-many relationship exists between two entities where the intermediate entity has nothing on it except the connecting roles. For example, it might be that an Employee can be assigned to many Regions, and each Region can have many Employees
Posted by bobmeyers | 8 Comments
Filed under: , ,
 
Page view tracker