Managing Oracle Apps User Passwords
1.Changing the oracle apps user password from
Database
DECLARE V_pwdchanged BOOLEAN;
BEGIN v_pwdchanged := fnd_user_pkg.changepassword('USER_NAME','welcome@123'); IF v_pwdchanged THEN DBMS_OUTPUT.put_line('password changed Sucessfully'); ELSE DBMS_OUTPUT.put_line('Failed to change the Password'); END IF; END;
2.Force All Application users to Change their password
The script to expire all passwords in the fnd_user table is $FND_TOP/patch/115/sql/AFCPEXPIRE.sql.
It can be executed from SQL*Plus or as a Concurrent Program: sqlplus -s APPS/ @AFCPEXPIRE.sql
or Submit concurrent request: CP SQL*Plus Expire FND_USER Passwords
This script sets the fnd_user.password_date to null for all users which causes all user passwords to expire. It can also be run as a SQL*Plus concurrent program.
The user will need to create a new password upon the next login. See the oracle Note for furthe…
DECLARE V_pwdchanged BOOLEAN;
BEGIN v_pwdchanged := fnd_user_pkg.changepassword('USER_NAME','welcome@123'); IF v_pwdchanged THEN DBMS_OUTPUT.put_line('password changed Sucessfully'); ELSE DBMS_OUTPUT.put_line('Failed to change the Password'); END IF; END;
2.Force All Application users to Change their password
The script to expire all passwords in the fnd_user table is $FND_TOP/patch/115/sql/AFCPEXPIRE.sql.
It can be executed from SQL*Plus or as a Concurrent Program: sqlplus -s APPS/ @AFCPEXPIRE.sql
or Submit concurrent request: CP SQL*Plus Expire FND_USER Passwords
This script sets the fnd_user.password_date to null for all users which causes all user passwords to expire. It can also be run as a SQL*Plus concurrent program.
The user will need to create a new password upon the next login. See the oracle Note for furthe…