question

venkatadinesh.g avatar image
venkatadinesh.g asked

sql server

Hi, I have an issue. I wanted to encrypt data in the sql db using cell level encryption on a table having > 1 Million rows. But tht column was clustered indexed and from web application we search the data based on the column. I heard there will lot of performance issues if we try to query a clustered index encrypted column. Please suggest. As an alternative I have a thought, don't know if this is appropriate or not. Would it be possible to provide column level permission on the specific column to be encrypted to a specific user and make the database Transparent Database encrypted ? So that we shall write some .net component at front end to show data as encrypted and when searched it will be searched based upon privileged user who have access to this column. Please suggest.
databaseencryptiontde
1 comment
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

What version & edition of SQL Server?
0 Likes 0 ·

0 Answers

· Write an Answer

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.