Post reply

Asymmetric Key Encryption

  • June 17, 2010 at 8:24 am

    #222877

    Hi All,

    I went through Symmetric and Asymmetric key encryption methods.My doubt is where we are specifying the public key for Asymmetric key encryption?

    I used ENCRYPTION BY PASSWORD for both and both worked.I didn't find any difference.

    Is it possible to use a public key for inserting data into a table a only a private key can read the data??

    I agree that Asymmetric is more powerful and consumes much resource.

    I tried Creating Symmetric Key with password,asymmetric key with password and then encrypting the symmetric key with Asymmetric key but while inserting only Symmetric password is necessary then what is the use?

    Can anyone please let me know which is the best way to encrypt the data in a database? The encryption should work in both 2005 & 2008?

    Please help.

  • June 17, 2010 at 11:33 pm

    #1181922

    I believe your unnescasaryilly compliticating your requirement.

    You'll need to choose 1 or the other and not mix the both for the same task at hand.

    SYMETRIC ENCRYPTION is by far better for performance reasons. I have used this option and it work well and it's secure. However, if you really wish to go one step further with the security side of things then by all means go for ASYMETRIC ENCRYPTION.

    Kindest Regards,

  • June 21, 2010 at 2:48 am

    #1182592

    Thanks a lot for the Reply..

    Can u point me right direction as I need to encrypt data in a column ..the data will be inserted by different users and one should not see other users data?? Insertion are on same columns

    How can i achieve this??

  • June 21, 2010 at 3:36 am

    #1182626

    The fact that different users will be Inserting data is irrelevant.

    All you need to do is encrypt the column/s in question and decrypt when retrieving.

    SYMMETRIC ENCRYPTION is your best choice but like I said, if you want that extra security then gof or ASYMMETRIC ENCRYPTION.

    Take a look at SYMMETRIC ENCRYPTION in BOL to see how easy this really is to Implement.

    Kindest Regards,

  • July 2, 2010 at 9:26 am

    #1188296

    You can have the best of both worlds, by encrypting the data columns with a symmetric key, but encrypting the symmetric key with an asymmetric key.

Viewing 5 posts - 1 through 4 (of 4 total)

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