March 14, 2013 at 7:45 am
I wanted to know some details about sql server encryption
a) What is the exact difference between encryptbypassphrase and encrypting using symmetric key which is protected by a password(while creating symmetric key it is encypted by using password not master key or certificate)
b)Which one is more secure in those two?
c) If i use the second method mentioned in question a) i.e encrypting using symmetric key which is protected by a password,then in any case after about a year if i want to change password then how it can be easily done?
March 14, 2013 at 11:25 am
winmansoft (3/14/2013)
I wanted to know some details about sql server encryptiona) What is the exact difference between encryptbypassphrase and encrypting using symmetric key which is protected by a password(while creating symmetric key it is encypted by using password not master key or certificate)
b)Which one is more secure in those two?
c) If i use the second method mentioned in question a) i.e encrypting using symmetric key which is protected by a password,then in any case after about a year if i want to change password then how it can be easily done?
b) The second one, a key have more random value than pass phrase, so it is dificult to crack them.
c) The password only protects access to a private key. So if you change them, the data that was encrypted by that key doesn’t need to be decrypted and encrypted.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply