| 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;
*************************
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
