Post reply

Sql Server 2005 security

  • November 26, 2007 at 9:27 am

    #200916

    I could able to encrypt the data with Asymmetric key creating based on master key.

    I have a doubt if i drop the key, can i recreate same key to decrypt the data. or how can i decrypt the column values when i drop the key.

  • December 2, 2007 at 12:59 pm

    #756298

    You do not drop the key or you will not be able to decrypt values. You assign users the ability to use the key. Typically you wouldn't encrypt with an asymmetric key, you'd use a symmetric key and encrypt that with the asymm key.

    This is a complicated subject. Please read BOL carefully as well as all articles you can find on encryption before building something with encryption.

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

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