Post reply

Insert using a view into a table having encrypted columns

  • May 24, 2017 at 2:13 pm

    #323724

    Hello All,

    I have a table that has encrypted columns in it. Currently, I'm using a view to present the encrypted columns using a select statment.

    I'm working on a view that will insert encrypted columns into this table. I wanted to check if someone has a recommendation as how to approach this situation. Any help will be greatly appreciated.

    Thanks

  • May 24, 2017 at 2:23 pm

    #1944076

    I prefer to use stored procedures for DML and handle encryption/decryption in the procedures.

  • May 24, 2017 at 3:03 pm

    #1944081

    Any other recommendations?

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply