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.
| Author |
Topic |
|
carumuga
Posting Yak Master
174 Posts |
 Posted - 2010-09-08 : 02:02:23
|
| Hi,I need to protect data at column level in the table in sql server 2005 for certain users. Could you please send me the solution/recommendation to achieve this.Thanks in advance |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2010-09-08 : 02:04:10
|
| Additional Info.Nothing to do with the encryption, just need to deny access for particular columns in the table for certain users. |
 |
|
|
carumuga
Posting Yak Master
174 Posts |
Posted - 2010-09-08 : 09:24:51
|
| Identified two approach to protect the sensitive data from unauthorized access1. Define a view where it has non-sensitive info and provide access to everyone.and protect the whole data in the underlying table.2. Deny access to the column level in the underlying table and you can provide access only to theuser who is authorized to view/manipulate.Please recommend the best approach to implement this solution. |
|
|
|
|
|
|
protect sensitive - column level