Some time there is a requirement to force application users to change their password.
for eg: to implement new validation password policy (role).
There is two ways to achieve this
1. through sql script
2. oracle application "expire day" setting at system administration responsibility --> user ---> there is a option to set expiration no of days.
1. through sql script
there is a script called 'AFCPEXPIRE.sql' located under $FND_TOP/patch/115/sql
eg: sqlplus -a APPS/APPS @AFCPEXPIRE.sql
Or
concurrent program called 'CP SQL*Plus Expire FND_USER Passwords'
No comments:
Post a Comment