ERPstuff - Oracle EBS Community

hi to all experts:

how to change password when time expired?And it give the small message box to user plz change your password, plz guide me how to do this plz help me if anyone wants to help me?
here is an example.

example:

step 1 Old password


step2 New password

Step3 confirm password

thanks in advance
sarah

Are you talking about Oracle Database User Name (schema) or you created a table where you stored all user related to your application ?

if it about schema User then use forms_ddl Sample Syntax like

V_DDL := 'alter user ' ||v_username ||' identified by ' || V_password;

-- execute the alter user statement
forms_ddl(v_DDL);

i am talking about on logon time it show a msg box to change u r password.i think its 30 days limitation or u can give more time but after finishng 30 days it will show a box to user to change his/her password during logon time.

sarah

This can be done at the time of creating user login you can set the expiry date so every time you need to login with new password as set.

I interest with this subject .
thanks