I am looking to implement Cell level security in my SQL Server database. I am building this database for a social-networking-like web application. It has the concept of a Group and a Group Member where a group member can restrict access to certain parts of his information. I have read through the article http://technet.microsoft.com/en-us/library/cc966395.aspx
about Label based security. My problem is that i am not sure whether Label based security would be able to provide cell level security when I'll be storing users of my application in a database table and not using SQL Server or Windows logins? Say I have a user 'Omer' in table 'Member' then how would Lable Based Security technique ensure security settings defined for this user? Thanks for providing assistance.
View Complete Post