Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Feb 16, 2009 09:30 PM by Mikesdotnetting
Feb 16, 2009 07:46 PM|LINK
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.
Feb 16, 2009 09:30 PM|LINK