Re: Changing Oracle passwords by end users
Date: 13 DEC 94 11:17:13 AST
Message-ID: <13DEC94.12190151.0130_at_UNBVM1.CSD.UNB.CA>
In article <3ck1ic$o7t_at_news.xs4all.nl> schaaph_at_xs1.xs4all.nl (schaaph) writes:
>: In article <3c1iu3$8d5_at_news.xs4all.nl> I wrote:
>: >From: schaaph_at_xs1.xs4all.nl (schaaph)
>: >Subject: Changing Oracle passwords by end users
>: >Date: 6 Dec 1994 11:46:10 GMT
>: >Hello world,
>: >has anybody ever tried to do the following for changing the Oracle password:
>: >- Let the user enter the old password en the new password twice.
>: >- The program should check the old password (to prevent a joker from
>: >changing the password on a deserted workstation)
>: >- The program should check if the two new entries are equal
>: >- The program should alter the password.
>: >Setup:
>: >Forms 3.0, Menu 5.0, Plus 3.1 on MS-DOS clients, Oracle 7.0 (on RS-6000).
>: >
>: >I would appreciate any pointer,
>
>Lawrence James (James.Lawrence_at_epamail.epa.gov) wrote:
>
>: You've got SQLForms, make a form that does that!
>: Lawrence....
>
>You make it sound trivial. Two questions: How to check the old password?
>(the only way I see is using a user exit)
Yes, that is the case.
And how to set the new password
>(can I use alter user statements in V2 style triggers?
You can call a procedure that executes a SQL statement, passed in a
charater string.
>Teijo Doornkamp (doornkampt_at_vertis.nl)
Andrew Jones (LRPR_at_UNB.CA) "##include <standard disclaimer>"
| "Give up, Earthlings! Your superior | | intelligence is no match for our puny | | weapons!" | | (The Simpsons' Halloween II Aliens) | ------------------------------------------Received on Tue Dec 13 1994 - 16:17:13 CET