Sunday, 2 September 2012

How To Force All Applications Users To Change Their Password?


sqlplus -s apps/******* ${FND_TOP}/sql/AFCPEXPIRE.sql

 SET VERIFY OFF
 SET linesize 132

 WHENEVER SQLERROR EXIT FAILURE ROLLBACK;
 WHENEVER OSERROR EXIT FAILURE ROLLBACK;
 REM dbdrv: none

/* ----------------------------------------------------------------------*/

 UPDATE FND_USER SET
   PASSWORD_DATE = NULL
 WHERE USER_ID <> 6;

 COMMIT;
 EXIT;

●● Alternately, you can submit "CP SQL*Plus Expire FND_USER Passwords" program to achive the same. This update all the user accounts except GUEST. Basically this program calls /u01/oracle/AGDEV1/apps/apps_st/appl/fnd/12.0.0/sql/AFCPEXPIRE.sql
●● 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.
●● If you need you can modify the script as per your need 

No comments:

Post a Comment