Changing the password when it expires.

[Renilkumar]

Hi,
We have developed a .net2.0 application using asp.net, vb.net and oracle9i. From the appl. we pass the datasource=;userid=;password=; to validate the username and password against the user_users table in oracle.
When the password is expired, We are forcing the user to change the password through a screen which uses...
ALTER USER <user> IDENTIFIED BY <newpassword> REPLACE <oldpassword>
But the moment this statement excecute in the appl, its throwing an error msg saying "your password has been expired" and not allowing the user to change the password.
The same password expired case, If I try to login using TOAD or SQLPlus, Its immediately throwing a dialog box to change the password.
Any idea how do I change my password when it expires ?

Thanks,
Renil.

[Shashi Sadasivan]

Hi,
We have developed a .net2.0 application using asp.net, vb.net and oracle9i. From the appl. we pass the datasource=;userid=;password=; to validate the username and password against the user_users table in oracle.
When the password is expired, We are forcing the user to change the password through a screen which uses...
ALTER USER <user> IDENTIFIED BY <newpassword> REPLACE <oldpassword>
But the moment this statement excecute in the appl, its throwing an error msg saying "your password has been expired" and not allowing the user to change the password.
The same password expired case, If I try to login using TOAD or SQLPlus, Its immediately throwing a dialog box to change the password.
Any idea how do I change my password when it expires ?

Thanks,
Renil.

Are you using the same credentials to change the password?
As in, the same username and password to execute the stored procedure to change the password for that username?

Technically, if the password has expired, you may not be able to login to do any of that ! .. unless the oracle mannual has defined a way to do so

[Renilkumar]

Hi,

Since I am using ODP driver, I used connection.OpenWithNewPassword("new password") to reset my password. Here is the sample C# code..

try {

cn.Open();

return cn; }

catch {

cn.OpenWithNewPassword(newpwd);

return cn; }

[radcaesar]

Hi,
We have developed a .net2.0 application using asp.net, vb.net and oracle9i. From the appl. we pass the datasource=;userid=;password=; to validate the username and password against the user_users table in oracle.
When the password is expired, We are forcing the user to change the password through a screen which uses...
ALTER USER <user> IDENTIFIED BY <newpassword> REPLACE <oldpassword>
But the moment this statement excecute in the appl, its throwing an error msg saying "your password has been expired" and not allowing the user to change the password.
The same password expired case, If I try to login using TOAD or SQLPlus, Its immediately throwing a dialog box to change the password.
Any idea how do I change my password when it expires ?

Thanks,
Renil.

How can u login after the password has been expired ?

[radcaesar]

Sorry, Yours is right since you have used ALTER USER..

Just Close the connection perfectly after your ALTER Operation and Open a new one.

Am not sure this is the solution, just try.