Implementing Row and Cell Level Security in Classified Databases Using SQL Server 2005
Art Rask, Don Rubin, and Bill Neumann have put together a great article explaining how to implement this functionality on SQL Server 2005. If you have a need for this type of database security, let us know.
-Marc