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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy