Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Database > Oracle ASP
Oracle ASP Using ASP with Oracle databases. For Oracle discussions not specific to ASP, please see the Oracle forum. For more ASP discussions, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Oracle ASP section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old October 23rd, 2006, 12:24 PM
Friend of Wrox
Join Date: Jul 2003
Posts: 121
Thanks: 1
Thanked 0 Times in 0 Posts
Default "ALTER USER.." command problem

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.
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,

Similar Threads
Thread Thread Starter Forum Replies Last Post
Why do i get erro when alter table command in ms s keyvanjan SQL Server 2000 2 June 30th, 2007 02:06 AM
how to alter shell command to direct where window dgr7 Beginning VB 6 4 March 16th, 2007 02:00 PM
"ALTER USER ..." commandproblem Dmitriy ASP.NET 1.0 and 1.1 Professional 5 October 23rd, 2006 01:13 PM
Help on 'Alter Table' command charuni Classic ASP Basics 0 April 14th, 2006 11:14 AM
Problem in ALTER TABLE statement deepakkhopade SQL Server 2000 4 November 1st, 2004 07:51 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.