How to trap password

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 2 Jul 2002 15:03:48 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA7024F4B33@lnewton.leeds.lfs.co.uk>

Off the top of my head, and depending on your version :

set up a user profile which forces the use of a function to encrypt (?) & validate the password for all users.
This function can then (a) validate the user password and (b) update your table with the new (encrypted) password.

HTH. Regards,
Norman.

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: chrisforbis_at_yahoo.com (Chris Forbis) [mailto:chrisforbis_at_yahoo.com]
Posted At: Tuesday, July 02, 2002 2:18 PM Posted To: server
Conversation: How to trap password
Subject: How to trap password

I need to store a users password in a format that can be used by my application without login a user in (I have an user that will have access only to the PW table)

I have a table like this
USER_ID : OracleUserID
PW_ENCODED : MD5 encoded password

I would like this MD5 encoded password to always be valid for a user. I need to be able to update it when a user alters there password. Ideas?

Is there a on alter password trigger?

Or better yet how does Oracle valid a user against a password, that would be a better place to get my job done.

Thanks! Received on Tue Jul 02 2002 - 09:03:48 CDT