Please help me to change user password in oracle apps from database.
Question
Share
Sign Up to our social questions and Answers to ask questions, answer people’s questions, and connect with other people.
Login to our social questions & Answers to ask questions, answer people’s questions & connect with other people.
Lost your password? Please enter your email address. You will receive a link and will create a new password via email.
Please briefly explain why you feel this question should be reported.
Please briefly explain why you feel this answer should be reported.
Please briefly explain why you feel this user should be reported.
Please help me to change user password in oracle apps from database.
Hi Sara,
you can use : fnd_user_pkg.ChangePassword API to change or reset password for any user from database like this:
[code]
DECLARE
l_user_name VARCHAR2(30):= UPPER(‘ORAASK’);
l_new_password VARCHAR2(30):= ‘welcome123’;
l_status BOOLEAN;
BEGIN
l_status := fnd_user_pkg.ChangePassword ( username => l_user_name,
newpassword => l_new_password);
—
IF l_status THEN
dbms_output.put_line (‘The password changed successfully for the User:’||l_user_name);
COMMIT;
ELSE
DBMS_OUTPUT.put_line (‘Unable to reset password due to’||SQLCODE||’ ‘||SUBSTR(SQLERRM, 1, 100));
ROLLBACK;
END IF;
—
END;
[/code]