Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
0
Reply
SQL2008 Cell Level Encryption
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
mark dinesh
11y
923
1
Reply
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.
Post
Reset
Cancel
Answers (
0
)
Next Recommended Forum
how to delete database in sql server 2008?
1NF,2NF,3NF in SQL Server 2005