ifsapp/ or ifssys user can not alter user passwords due to below error. What could be the cause. all user management privileges were already been granted.
---------------------------
Error - IFS Applications
---------------------------
IFS Application Owner must have System privilege "ALTER USER" to execute this method.
---------------------------
[OK]
---------------------------
Best answer by Ragaventhan Sathananda
View original
+15
Hi
Yes you need to provide Alter user grants to the specific user to change passwords to other users in the system. You need to have FND_ADMIN permission set granted to those users to alter other users passwords. It is recommended to have that only to IFSAPP.
Hope this helps you!
Hi
Please login to the DB as SYS and try to alter the password .
As SYS is the oracle admin account it should have authority to alter passwords.
Thanks!
Bhagya
+15
Hi
You may try executing the below script on the database to make the IFSAPP to alter other user passwords. After the execution you need to Refresh Security Cache of the system through Refresh Cache window on the Application. You need to refresh security every time you do any alteration for user permission set or grants.
BEGIN
Prepare_SYS.Dbagrant('<Application Owner>', 'Y');
END;
Thanks Ragaventhan and Bhagya.
This helped.
Kind regards
KMH
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
