Post reply

Storing password in database

  • November 10, 2006 at 8:18 am

    #175353

    How can I store passwords in the database for users with encryption?

    I have a table user with username and password as columns?Is there a way to store passwords in the databse with encryption? or Is there anything else to store passwords in SQL server 2005

    Thanks,

    Prasad

  • November 10, 2006 at 9:37 am

    #671132

    Do you need to read the passwords? Or just use them for comparisons?

    You can use a one way hash, smoething like encrypt() if you don't need to read them. If you do need to read them back, then you'd want to read some articles, create a key to encrypt the data, encrypt the key and assign rights to the decrpytion key for whichever process needs it.

    http://www.sqlservercentral.com/columnists/mcoles/sql2005symmetricencryption.asp

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

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