Post reply

security behind DecryptByPassphrase & EncryptByPassphrase

  • January 1, 2009 at 1:29 pm

    #217047

    is DecryptByPassphrase secured to use in order to encrypt a column value..

    I'm able to encrypt and Decrypt a column value using encryptByPassphrase & DecryptByPassphrase

    easily.But i dont know how secured these methods are? Is it possible to break the password and know the columna value..

    Please help me on this.

  • January 1, 2009 at 1:50 pm

    #920023

    As I asked before, have you read through the sections in Books Online on the encryption hierarchy and how the encryption works?

    A very quick google search on EncryptByPassphrase turned these up.

    http://technet.microsoft.com/en-us/library/ms189586.aspx

    http://www.pluralsight.com/community/blogs/dan/archive/2006/04/09/21375.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • January 2, 2009 at 10:21 am

    #920414

    Thanks for the reply.

    SELECT seed_time,seed_encrypt,

    CONVERT(int,DecryptByPassphrase(@pass, seed_encrypt)) AS Decrypt_Seedtime

    FROM TestTable

    if the seed_time column data type is integer, i'm not getting the exact value of seed_time when i decrypt. how to get the exact value if i use integer data type.

    Please help me on this

  • November 12, 2009 at 11:48 pm

    #1078717

    yes, it is possible once we get value that column then we can found actual value of that column.

    Regards.

    Yours

    Regards,
    Tatoba

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

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