I have a question about SQL Server 2005 Encryption. Is there a way to encrypt an entire database (or selected columns) and then selectively grant access to certain columns based on individual or group priviledges? For example the entire database is encrypted but Bob has read access to fields 1,2,5 and 9 based on his privs and Steve has access to fields 4,5,6 based on his privs while Ted has no access at all. When I say encrypt the database or selected columns I mean do this via the managment interface not programatically. Otherwise if the only way to do something like this is programatically and that means current applications would need to be modified...which would be BAD.