Home » Infrastructure » Unix » Urgent !!! not prompting user to change password
Urgent !!! not prompting user to change password [message #149213] Wed, 30 November 2005 10:11
preserve
Messages: 1
Registered: November 2005
Junior Member
I have written one shell script for changing the password for an oracle application user. It is changing password, but when user logs in to application it is not forcing user to change password again. It means after changing the password by admin, user can directly go to the application. Actually applications is supposed to force user to change password.

here is the code

***************************
#!/bin/sh
. /abcafs/abcappl/APPSORA.env
read USERID?"Enter the Userid that needs Reset > "
read PASS?"Enter the password for this userid > "
`/abcafs/abcappl/fnd/11.5.0/bin/FNDCPASS apps/xyz 0 Y system/abcef5 USER ${USERID} ${PASS}`

USER_LOGIN=$1
sqlplus -s apps/xyz@abc <<EOF
set serveroutput on size 10000;
set pagesize 0;
set heading off;
set verify off;
--set term off;
set feedback off;
begin
update fnd_user
set end_date = TO_CHAR(NULL, 'MM/DD/YYYY'),
password_date = TO_CHAR(NULL, 'MM/DD/YYYY')
where user_name = '${USERID}';
commit;
end;
/
exit;
*************************
Previous Topic: need help in shell script
Next Topic: Help me ...spent a long time on this issue
Goto Forum:
  


Current Time: Fri Mar 29 05:11:31 CDT 2024