Skip to Main Content

ODP.NET

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Change user password using "ALTER USER..." command

541346Nov 6 2006 — edited Oct 8 2010
Hello Forum Members,

I am experiencing very interesting problem in my ASP.NET application when I am changing the user password in ORACLE database using "ALTER USER..." command from inside of my code.
Example:
The user "TestUserName" has the current password, let's say "User1".
After I change the password to "User2", I can login into my application with the OLD and with the NEW passwords by some reason?
If I check the password for the current "TestUserName" in the database, it has the newest value ("User2"). From the SQLPlus I can login into the database only with the newest password. But from my application I can still login using both passwords? If I close the application, close the browser and start the application again, I still can login using two passwords. But, if I restart the PC, the old password disappeared. What is going on?

Any suggestions?

Thanks in advance,
-Dmitriy
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 5 2010
Added on Nov 6 2006
7 comments
6,350 views