SQL Server 2008 EF 4 - limiting database records returned using permissions?
- by Chuck
In our database all tables are linked back to a single table. This table has a bit column to limit whether the record is displayed. Currently the records are filtered on the code side of the website.
Is there any way to set up permission so that userA would never see any record in the database where that common bit column was set to true?
We are using SQL Server 2008.
Alternatively we are also using entity framework 4.0 in .net 4 (in c#) if you have any ideas how it might be accomplished there?
Thanks for your feedback.