Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2011

    Unanswered: Transparent encryption on a column


    How can i encrypt data (a column) when they're stored and decrypt them automatically when they're used without changing the way the application is retrieving the column? Meaning, how can i simplify application development by performing all encryption transparently at the database level? Is this possible in MSSQL?

  2. #2
    Join Date
    Jan 2003
    Provided Answers: 11
    You can use Transparent data encryption at a database level, but I do not think you can do that at a column level.

  3. #3
    Join Date
    Nov 2004
    Provided Answers: 4
    You can program encryption and decryption in the Getter and Setter methods of your class encapsulating the table. The rest of your program won't notice.

    If you use SQL throughout your program, this won't work.
    With kind regards . . . . . SQL Server 2000/2005/2012

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  4. #4
    Join Date
    Jul 2011
    Cheers, thanks for the response guys. However, maybe i shouldn't have used the term 'Transparent'. What i was trying to ask is if there is a way to encrypt data when storing into the database and decrypting when reading from the database using the application that i have written. My application uses normal SQL statements to retrieve data. Meaning, is there like a layer between the database and the application that can do this?


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts