Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2014

    Unanswered: How to Decrypt a password in SQL

    I have a set of Password data in a table which is encrypted e.g. UOTYoeUK8ae89IM6PKButX5ssew= , i was wondering how to decryted it so that it reveals the passwords.

    Thank you

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    you match encrypted passwords
    ie user keys in password
    something, somewhere encrypts that entry using the same encryption key as the stored password
    you compare both encrypted values, NOT the unencrypted userinput and the decrypted stored password

    doing it the other way means there is a means for someone to secure access to the password the user is using. that means there is a security vulnerability, especailly as users are fairly dumb on passwords (they use the same passwords accross multipel systems, or they use variation of passwords.
    Last edited by healdem; 06-04-14 at 06:34.
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Feb 2013
    perth australia

    Typically I try to find the username/password from the middle tier box which connects to SQL server thru a sql connection string. Easier this way than to try to de-crypt the password in your table.

    Woon Thong

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