5 Replies Latest reply on Nov 30, 2013 3:33 PM by wozigbo

    Change user Password through form

    Adeel Qadir

      Hey Allzzzzz.

      Is there any way to change user password through form ?

      i means when user click Change Password button or Menu then a New Form open with 3 fields

      Old Password
      New Password
      Verify new Password

      if 3 of all fields are true then user password has been changed.

      Need it in Forms 6i

        • 1. Re: Change user Password through form
          Priyasagi

          If you are a owner of the program then it is possible.

          • 2. Re: Change user Password through form
            O.Developer

            Do you mean to change  user's  password  in FORMS  or  users  Database login

            • 3. Re: Change user Password through form
              KevinD.Clarke

              Trying to remember 6i (how many decades ago ?) .. doesn't the standard login box allow this ?

              • 4. Re: Change user Password through form
                Adeel Qadir

                Yes i want to change user Login password.

                I have a Menu name is CHANGE PASSWORD

                I want to do that when user pressed CHANGE PASSWORD

                New form open up and user change their password on this form

                • 5. Re: Change user Password through form
                  wozigbo

                  DECLARE

                      al_button number;

                      v_username number;

                      ncount number;

                  BEGIN

                  Study the code below:

                   

                   

                      IF :password.psd_word IS NULL OR     

                          :password.con_psd_word IS NULL  THEN

                          Set_Alert_Property('gen_msg',Alert_Message_Text,'Please, enter/confirm password');

                          al_button := Show_Alert('Gen_Msg');

                          GO_Item('password.psd_word');

                          Raise Form_Trigger_Failure;

                   

                   

                       ELSIF :password.psd_word <> :password.con_psd_word THEN

                         Set_Alert_Property('gen_msg',Alert_Message_Text,'The new password was not correctly confirmed');

                         al_button := Show_Alert('Gen_Msg');

                         GO_Item('password.con_psd_word');

                         Raise Form_Trigger_Failure;

                   

                   

                     END IF;

                   

                         -- ** now, confirm whether to save

                          Set_Alert_Property('yes_or_no', alert_message_text,'Do you want to change your password now?');

                          al_button := Show_Alert('yes_or_no');

                          IF al_button = alert_button1 then   -- ok was pressed                     

                   

                   

                        forms_ddl('alter user '||:GLOBAL.the_username||' identified by '||:password.psd_word);

                      if not form_success then

                         message('problem encountered changing user password');    message('');

                            raise form_trigger_failure;

                      end if;

                   

                             clear_block(no_validate);

                             go_item(:GLOBAL.home_item);

                             hide_window('password');

                           else

                             null;

                           END IF;

                  END;