Re: How to trap password

On Tue, 02 Jul 2002 20:31:26 +0200, Svend Jensen <Svend_at_OracleCare.Com> wrote:

>Chris Forbis wrote:
>
>> 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!
>>
>
>A password change must hit the sys.user$.password table/column if you
>are using database auth. Thats a must for this solution.
>A after update trigger on this could keep the PW table up to date.
>
>/Svend

You can't create triggers on the real dictionary tables. PERIOD.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Jul 02 2002 - 14:22:43 CDT