Skip to main content

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]    
---------------------------
 

Hi @CedKanchM ,

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 @CedKanchM ,
 

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


Hi @CedKanchM 

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