Change\Expire all application users password forcefully
We can forcefully expire password for all EBS user.This feature is available after RUP4.We need to apply Patch 4676589 ATG RUP 4 enabling this feature.
Script:
The below script can be used to expire all passwords in the fnd_user table $FND_TOP/sql/AFCPEXPIRE.sql.
Execution Method
Connect to SQL*Plus
sqlplus APPS/ APPSPASSWORD
@AFCPEXPIRE.sql
OR
Submit Concurrent Program
CP SQL*Plus Expire FND_USER Passwords
Note:
This script sets the fnd_user.password_date to null for all users which causes all user passwords to expire.The user will need to create a new password upon the next login.
Script:
The below script can be used to expire all passwords in the fnd_user table $FND_TOP/sql/AFCPEXPIRE.sql.
Execution Method
Connect to SQL*Plus
sqlplus APPS/ APPSPASSWORD
@AFCPEXPIRE.sql
OR
Submit Concurrent Program
CP SQL*Plus Expire FND_USER Passwords
Note:
This script sets the fnd_user.password_date to null for all users which causes all user passwords to expire.The user will need to create a new password upon the next login.
Subscribe to:
Post Comments
(
Atom
)
Posts
Good Post! Thank you so much for sharing this pretty post, it was so good to read and useful to improve my knowledge as updated one, keep blogging…
ReplyDeleteAWS Training in Bangalore|