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