PL/SQL Script to Reset User Password from Backend

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

/************************************************************
*PURPOSE: To change/reset password of a user from backend   *
*AUTHOR: Shailender Thallam                                 *
*************************************************************/
SET serveroutput ON;
DECLARE
  v_user_name    VARCHAR2(30):= UPPER('SYSADMIN');
  v_new_password VARCHAR2(30):= 'welcome1';
  v_status       BOOLEAN;
BEGIN
  v_status   := fnd_user_pkg.ChangePassword ( username => v_user_name, 
                                              newpassword => v_new_password 
                                            );
  IF v_status  THEN
    dbms_output.put_line ('The password reset successfully for the User:'||v_user_name);
    COMMIT;
  ELSE
    DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100));
    ROLLBACK;
  END IF;
END;

/************************************************************ *PURPOSE: To change/reset password of a user from backend * *AUTHOR: Shailender Thallam * *************************************************************/ SET serveroutput ON; DECLARE v_user_name VARCHAR2(30):= upper('SYSADMIN'); v_new_password VARCHAR2(30):= 'welcome1'; v_status BOOLEAN; BEGIN v_status := fnd_user_pkg.ChangePassword ( username => v_user_name, newpassword => v_new_password ); IF v_status THEN dbms_output.put_line ('The password reset successfully for the User:'||v_user_name); COMMIT; ELSE DBMS_OUTPUT.put_line ('Unable to reset password due to'||SQLCODE||' '||SUBSTR(SQLERRM, 1, 100)); ROLLBACK; END IF; END;