how to change password during login when password

To discuss Oracle Forms & Reports related technical issues.
Post Reply
sarahaman
Posts: 7
Joined: Fri Jul 17, 2009 4:58 pm
Location: Qatar

how to change password during login when password

Post by sarahaman »

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
ahmadbilal
Posts: 615
Joined: Mon Sep 18, 2006 1:32 am
Location: United Arab Emirates
Contact:

Post by ahmadbilal »

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);
sarahaman
Posts: 7
Joined: Fri Jul 17, 2009 4:58 pm
Location: Qatar

Post by sarahaman »

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
qamer.financial
Posts: 59
Joined: Fri Oct 05, 2007 1:15 am
Location: Saudi Arabia

Post by qamer.financial »

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.
MuhammadYassein
Posts: 1
Joined: Thu Sep 08, 2011 3:16 am
Location: Egypt
Contact:

Post by MuhammadYassein »

I interest with this subject .
thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests