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

    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
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    y'dont
    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
    Location
    perth australia
    Posts
    24
    Hi,

    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
  •