Encrypted password in DB and reused later

  • Hi guys...

    My question....

    I built an vb.net app that set some parameters and runs a store proc. Besides, the vb.net app creates an user with admin rights, his credentials: username and password are stored in DB.

    I thouth to encrypt password with hash + salt method.

    The problem....

    Hashing password means that they are not decrypted ...only compared ..and here the problem....

    I would like to reuse this password to be used in the addlinked server store proc and other sql statement.

    How can I Manage encrypted password to be used later...

    If I use

    thank for any suggestion....

  • If you want to go down this road, you're going to need to use an encryption algorithm which is a two-way function. Hashing functions won't do it for you, since they are one way.

    K. Brian Kelley
    @kbriankelley

  • Hi, you write:

    If you want to go down this road....

    If there is onother solution ..... o better road.....tell me....

    In the case I carry on my initial road ...what are the other encryptyon technics to have two-way function...are secure too?

    Thank

     

     

  • If you want to re-use the password, then it is no different than data you are encrypting with respect to how to handle the encryption. In this particular case hashing functions, which you can only go from unencrypted text to some encrypted text, you can't go back, do you no good. You need two way functions that allow you to go from unencrypted to encrypted and back. There are numerous secure two-way functions.

    It sounds like you don't have a lot of background in cryptography. You might want to start here:

    Info:Cryptography Basics

    It'll give you a better understanding of what cryptography is, what to look for in secure algorithms, etc., in a whole lot more comprehensive means than I can do in a forum post.

    K. Brian Kelley
    @kbriankelley

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

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