Thanks for the replies guys - the one way hash stuff from 4guys looks like just the ticket! I realise that since I am the actual author of the software, there are many other ways that I can 'hack' the system, but plain text visible passwords in the database was something the client picked up on, hence my original question! Thanks to all :-) Mark.
"Ross St. Clair" <[EMAIL PROTECTED]> wrote: Mark, This is the method I'm using to do just what you're asking: http://www.4guysfromrolla.com/webtech/010100-1.shtml This method uses RC4 encryption and I'm storing the result in a memo field in my Access DB. I found this to be fairly straight-forward and haven't encountered any issues in the nearly three years it's been in use on my project. I hope this helps. -- Ross St. Clair --- mark wills <[EMAIL PROTECTED]> wrote: > > Hi there. > > I am writing an 'classic' asp app. I would like to know if it's > possible to store the passwords of each user in a user table in an > encrypted form, so that the db admin person (i.e. me!!) can't > impersonate users by viewing the Users table and simply using some > elses username and password. > > Any thoughts on this friends? > > Mark Wills (UK) > > > http://www.natalie-merchant-online.com > > --------------------------------- > ALL-NEW Yahoo! Messenger - sooooo many all-new ways to express > yourself > > [Non-text portions of this message have been removed] > > > > ------------------------ Yahoo! Groups Sponsor > --------------------~--> > Yahoo! Domains - Claim yours for only $14.70 > http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/17folB/TM > --------------------------------------------------------------------~-> > > > --------------------------------------------------------------------- > > Home : http://groups.yahoo.com/group/active-server-pages > --------------------------------------------------------------------- > Post : [EMAIL PROTECTED] > Subscribe : [EMAIL PROTECTED] > Unsubscribe: [EMAIL PROTECTED] > --------------------------------------------------------------------- > > Yahoo! Groups Links > > > > > > __________________________________ Do you Yahoo!? New and Improved Yahoo! Mail - Send 10MB messages! http://promotions.yahoo.com/new_mail --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups SponsorADVERTISEMENT --------------------------------- Yahoo! Groups Links To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ To unsubscribe from this group, send an email to: [EMAIL PROTECTED] Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. http://www.natalie-merchant-online.com --------------------------------- ALL-NEW Yahoo! Messenger - sooooo many all-new ways to express yourself [Non-text portions of this message have been removed] ------------------------ Yahoo! Groups Sponsor --------------------~--> Make a clean sweep of pop-up ads. Yahoo! Companion Toolbar. Now with Pop-Up Blocker. Get it for free! http://us.click.yahoo.com/L5YrjA/eSIIAA/yQLSAA/17folB/TM --------------------------------------------------------------------~-> --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [EMAIL PROTECTED] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
