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