Re: Storing password in informix database

If you are on 9.x versions (with the WEB Datablade installed) , you can use a function called webpwcrypt which will encrypt your password and store it in the database. Otherwise, I would assume you'll have to write your own algorithm to do the same. The usage is as follows: select webpwcrypt(password,2194) from user where the second parameter is some kind of a seed# to generate the encrypted password. HTH. Thanx much, Rajib Sarkar Advisory Support Engineer (RAS) IBM Data Management Group Ph : (602)-217-2100 Fax: (602)-217-2100 As long as you derive inner help and comfort from anything, keep it -- Mahatma Gandhi "Chavan Koya" <chavankoya189@ho To: "Informix Mailing List" <informix-list@iiug.org> tmail.com> cc: Sent by: Subject: Storing password in informix database owner-informix-li st@iiug.org 07/11/2003 08:22 AM Hello All, Is there any way to show the selected password field value from a table as *********, but should match the actual value when comparing for login. Thanks in advance. Chavan Koya sending to informix-list