Sorry if this question is too simple, I am new to ASP. I am working on an application where I would like the users to be able to change their Oracle passwords using ASP forms. The passwords are not stored in any table in the database as they are OS authenticated.
I have a table called USER_INFORMATION which has USER_NAME, USER_ID, ROLE_ID, LAST_PASSWORD_CHANGE_DATE etc..
Old password can be retrieved as follows: Old Password = <%=Session("LoginPassword")%>
I would also like to update the LAST_PASSWORD_CHANGE_DATE field to Date() when a user changes his/her password. I am assuming this can be done using the following SQL statement:
update USER_INFORMATION set LAST_PASSWORD_CHANGE_DATE = Date() where USER_ID = <%=Request.QueryString("UserID")%>
once the form is able to change the password.
The passwords in Oracle(8i) are set to expire every 30 days, so if the functionality which warns the users to change their passwords 5 days before they expire can be added, that will be really helpful.
Are you using classic ASP (pages end in .asp)? If so, this forum covers ASP.NET (pages end in .aspx) which is totally different. You should ask your queston at http://forums.iis.net/1032.aspx
chambal
0 Points
1 Post
How to change Oracle Password using ASP
Feb 16, 2009 07:46 PM|LINK
Hi,
Sorry if this question is too simple, I am new to ASP. I am working on an application where I would like the users to be able to change their Oracle passwords using ASP forms. The passwords are not stored in any table in the database as they are OS authenticated. I have a table called USER_INFORMATION which has USER_NAME, USER_ID, ROLE_ID, LAST_PASSWORD_CHANGE_DATE etc..
Old password can be retrieved as follows: Old Password = <%=Session("LoginPassword")%>
I would also like to update the LAST_PASSWORD_CHANGE_DATE field to Date() when a user changes his/her password. I am assuming this can be done using the following SQL statement:
update USER_INFORMATION set LAST_PASSWORD_CHANGE_DATE = Date() where USER_ID = <%=Request.QueryString("UserID")%>
once the form is able to change the password.
The passwords in Oracle(8i) are set to expire every 30 days, so if the functionality which warns the users to change their passwords 5 days before they expire can be added, that will be really helpful.
Thanks,
G. Chambal
Mikesdotnett...
All-Star
154818 Points
19853 Posts
Moderator
MVP
Re: How to change Oracle Password using ASP
Feb 16, 2009 09:30 PM|LINK
Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter