Q:

Record Level Security in SQL Server

How would you go about implementing record level security in SQL Server? 
EDIT:
I've a requirement to restrict data based on user's privileges. Lets say I've a table of Contacts. I should be able to restrict the set of data that a user can see. Hope this helps :-)

A:

Here's an older article on Implementing row level security in SQL Server databases which may provide some info.

