473,594 Members | 2,756 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Changing the password when it expires.

26 New Member
Hi,
We have developed a .net2.0 application using asp.net, vb.net and oracle9i. From the appl. we pass the datasource=;use rid=;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.
Oct 24 '07 #1
4 4317
Shashi Sadasivan
1,435 Recognized Expert Top Contributor
Hi,
We have developed a .net2.0 application using asp.net, vb.net and oracle9i. From the appl. we pass the datasource=;use rid=;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
Oct 24 '07 #2
Renilkumar
26 New Member
Hi,

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

try {

cn.Open();

return cn; }

catch {

cn.OpenWithNewP assword(newpwd) ;

return cn; }
Oct 29 '07 #3
radcaesar
759 Recognized Expert Contributor
Hi,
We have developed a .net2.0 application using asp.net, vb.net and oracle9i. From the appl. we pass the datasource=;use rid=;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 ?
Oct 29 '07 #4
radcaesar
759 Recognized Expert Contributor
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.
Oct 29 '07 #5

Sign in to post your reply or Sign up for a free account.

Similar topics

4
6059
by: Lobang Trader | last post by:
Hi all, I am trying to create a username and a password class. I would like to know what are the RECOMMENDED minimum and maximum length for both fields? These fields will be something like this: private static final int DEFAULT_MINIMUM_LENGTH = ??????
4
3840
by: ecPunk | last post by:
Hi, We have a web application where we want a user to be able to change his/her password if the password has expired but we are unable to do this with ASP (at the moment) because we can't log the user into the database without a valid password. We do not want to store any "admin" user info to connect to the database to change the users password for security issues. Does anyone have any ideas of how we could go about doing this? Any...
7
3016
by: dlinetsky | last post by:
I have a C# web app that uses mixed mode authentication (windows integrated auth. together with formsAuthentication). I would like to have a form that allows users to change their windows passwords remotely. Does anyone know how I could do this?
2
1180
by: Elroyskimms | last post by:
The form has two text fields... one called txtEmail and one called txtPassword. The username is the email address (txtEmail) and the password is txtPassword. Storing cookie using the following code: Response.Cookies("Email").Value = txtEMail.Text Response.Cookies("Email").Expires = DateTime.Now.AddDays(30) The cookie is accessed using the following code: txtEMail.Text = Request.Cookies("Email").Value
0
3666
by: GregS | last post by:
We have a client that has a very large number of users that will be connecting back to the domain via VPN only. The problem is that the communications vendor can not pass the password expiration notice back to the client. What we would like to do is run a script or application after the vpn tunnel is established that checks the number of days remaining before the password expires and then give the user a prompt to change their password when a...
21
2935
by: solomon_13000 | last post by:
I am using ms access database and asp 3.0 as my front end. In my database there is a table called account and a field called password. How do I protect the password stored in the database.
1
7419
by: roshina | last post by:
Hi Iam facing a problem in my project, developing a web site for online shopping in ASP on windows XP using IIS server. All the validations are ok but the new password is not upadated in the data base and also showing a error page. the operating system we used is Windows XP, the source code is ASP, front end we used - HTML and javascript and vb script for validations. the inputs we used are : old pasword :
4
4887
by: John Kotuby | last post by:
Hi all, I have a simple user-form which accepts contact and profile information for the user to edit and save. All the textboxes are working fine and displaying the expected data, both when the screen is first displayed and after a save of changed data. The text boxes are being populated during the Page_Load event. However, when I change the TextMode property to PassWord, as I have 2 password textboxes (one for confirmation) no data...
0
3084
by: shashank kadge | last post by:
You can set it to integer, if u dont want to use ADS constant. 544 - to enable the user object 66048 - for Password never expires in addition to enabling user object. 66080 - for enabling user object and also User cannot change password & password never expires. example: oUser.Properties.Value = 66048;
0
7946
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
8372
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
8003
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
8234
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
6654
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
3859
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
3897
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2385
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1478
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.