Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> How to trap password

How to trap password

From: Chris Forbis <chrisforbis_at_yahoo.com>
Date: 2 Jul 2002 06:18:00 -0700
Message-ID: <f2dc430d.0207020518.32771f37@posting.google.com>


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 - 08:18:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US