Results 1 to 4 of 4
  1. #1
    Join Date
    Jun 2014
    Posts
    8

    Question Unanswered: Decrypting password field in SQL

    Hi ive got a encrypted column in sql which holds the password field, e.g. TPSK9RlOz0/2BhuQntVeaBda+9g=, is their a way in a select statement to get the password ?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    why woudl you want to. if there was a method to do so then de facto you have trashed any pretence at security and any reason to encrypt in tbhe first place.

    why do you feel you need to decrypt a password?

    normally you'd comapre the password supplied by the user, suitable encrypted to match against the encrypted value in the db
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    If you know the passphrase (the key) that was used to encrypt the original data, you can use the function DECRYPTBYPASSPHRASE.

    Code:
    SELECT DECRYPTBYPASSPHRASE('secret private key', 'TPSK9RlOz0/2BhuQntVeaBda+9g=')
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

  4. #4
    Join Date
    Nov 2004
    Posts
    1,427
    Provided Answers: 4
    ^^^

    (text to make the message at least 10 chars long)
    With kind regards . . . . . SQL Server 2000/2005/2012
    Wim

    Grabel's Law: 2 is not equal to 3 -- not even for very large values of 2.
    Pat Phelan's Law: 2 very definitely CAN equal 3 -- in at least two programming languages

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •