Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Column Level Encryption / Cell Encryption

Author  Topic 

hwood125
Starting Member

12 Posts

Posted - 2008-10-24 : 14:04:36

Does anyone know any good articles on how to set up column level encryption based off of logins or different types of users?

There are plenty of simple articles out there for column level encryption but I haven't found any that dig deep into it. I am looking to set this up in SQL Server 2008 based on logins or users. I know about Transparent Encryption but I want to narrow it down to what the users can see.

Thanks!

saurabhsrivastava
Posting Yak Master

216 Posts

Posted - 2008-10-27 : 22:43:15
I don't think you can set up encryption based on logins. Btw- You can create views and set up roles to restrict users from accessing all columns.
Go to Top of Page

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2008-10-28 : 05:21:29
read this
http://weblogs.sqlteam.com/mladenp/archive/2006/08/12/11153.aspx

_______________________________________________
Causing trouble since 1980
Blog: http://weblogs.sqlteam.com/mladenp
Speed up SSMS development: www.ssmstoolspack.com <- version 1.1 out!
Go to Top of Page
   

- Advertisement -