Re: Allow user to change database password in Forms 5.0
Date: 1998/01/24
Message-ID: <34C994DF.B299A64C_at_prodigy.net>#1/1
I had the same requirement, and here it is how I did it.
I created a single block form with following fields:
username,old_password,new_password,repeat_new_password and button apply.
After user enters all required data into these fields, and presses 'apply'
button
then W-B-P trigger fires the following code :
forms_ddl('alter user '||user_name||' set password = '||:new_password);
(check this synthax...)
Helpfull hints:
Make user_name item nonenterable and nonupdatable and populate it in
W-N-F-I trigger
by get_application_property(username) built in to prevent other users to
change somebody elses password.
Hope this helps...
Novak L.
Jeff Pierson wrote:
> I am trying to find out how to let a user change his database password
> in a Forms 5.0 form. I have been unable to find any help in the
> documentation. Does anyone out there know a good way to do this?
>
> Thanks,
> Jeff Pierson
> Worldcom
> jeff.pierson_at_wcom.com
Received on Sat Jan 24 1998 - 00:00:00 CET