Password field encryption

  • patilds

    SSChasing Mays

    Points: 615

    Hello,

    I have a user table with fields :

    userid varchar(30),

    password varchar(10)

    How can I encrypt the password and store in password field? is there any function available or I will have to write my own encryption algorithsm in stored procedure?

    Thanks.

  • Andy Warren

    SSC Guru

    Points: 119675

    If you do it with a stored procedure you're still sending it over the wire unencrypted. Depends on how much risk you can handle.

    Andy

  • patilds

    SSChasing Mays

    Points: 615

    But then how do i encrypt the data. Is there any encryption function available? I dont mind sending data unencrypted but data should be encrypted when it is stored.

  • GRN

    Hall of Fame

    Points: 3210

  • K. Brian Kelley

    SSC Guru

    Points: 114455

    You might also try the Counterpane Labs site. Counterpane Internet Security was co-founded by Bruce Schneier, author of Applied Cryptography:

    http://www.counterpane.com/labs.html

    It has some algorithms and links to other cryptography sites.

    K. Brian Kelley

    bk@warpdrivedesign.org

    K. Brian Kelley
    @kbriankelley

  • patilds

    SSChasing Mays

    Points: 615

    Thanks. Going to use Encrypt function.

Viewing 6 posts - 1 through 6 (of 6 total)

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