Re: Allow user to change database password in Forms 5.0

From: Shujda <shujda_at_prodigy.net>
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

Original text of this message