Storing Password safe inside a table

Question

Storing Password safe inside a table

Larsi1971

Ten Centuries

Points: 1081
More actions
September 24, 2003 at 6:48 am

#106600

Hello!
How can I store a password for a user safe? Do I use varbinary or another fieldtype?
I want my application to use the application role, and I need this information about the password to login. Then I'm shure that no one is able to view this site other than the SA, but that's not good enough.
Please help me.
Regards - Lars

-Lars

Please only reply to this newsgroup. All mails would be bounced back.

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

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

Greg Larsen SSC-Insane Points: 20961 More actions · Answer 1

I would suggest that you hash the passwords and then store them in you database. This will keep anyone even the SA from knowing the password. Now if you do need to be able to know the password under special conditions, then encryption is an alternative. This way you can de-crypt the password if needed.

Gregory Larsen, DBA

If you looking for SQL Server Examples check out my website at http://www.geocities.com/sqlserverexamples

Gregory A. Larsen, MVP

Vishal_rinkoo SSC-Addicted Points: 465 More actions · Answer 2

How to hash a password?

I am using encrypt function but when I run the select query keeping result in text mode on .then I am able to see all the passwords.

I am using SQL2000, it is not a case with sql 7. I have checked it.

geckomaniak Valued Member Points: 69 More actions · Answer 3

Encrypt isn't a hash. A hash is one way. SQL will de-crypt the encrypted data for you if you are SA, but data readers and writers will not be able to see it.

For application passwords, the passwords are usually hashed with md5 or sha1. -rich

subhashkvsql Old Hand Points: 372 More actions · Answer 4

quote:
How to hash a password?
I am using encrypt function but when I run the select query keeping result in text mode on .then I am able to see all the passwords.
I am using SQL2000, it is not a case with sql 7. I have checked it.

i am using encrypt function

for eg.

update employee set password=encrypt(password)

but i don't know how to decrypt it?

any suggestions?

hbkdba Ten Centuries Points: 1224 More actions · Answer 5

>update employee set password=encrypt

>(password)

>but i don't know how to decrypt it?

Being unable to decrypt gives you better

security ...

subhashkvsql Old Hand Points: 372 More actions · Answer 6

yes, it is secure, but one of my JAVA application need plain password, so i want to decrypt it and store in a seperate table