Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2005
    Posts
    4

    Question Unanswered: Reset Expired Password

    I'm developing an applicaion with C# and I would like the user to be able to change his/her password when it has expired.

    This will more likely happen when the user is created.

    Is there any way to do this from C#?

    Thank you,

    JFercan

  2. #2
    Join Date
    Sep 2005
    Posts
    4
    I just realized that Postgresql does not differentiate between an invalid username/password or an expired password when it gives you the error message.

    Therefore I have to look for a different way to allow users to select their own passwords.

    Thank you,

    JFercan

  3. #3
    Join Date
    Jun 2004
    Location
    Arizona, USA
    Posts
    1,848
    Quote Originally Posted by JFercan
    I just realized that Postgresql does not differentiate between an invalid username/password or an expired password when it gives you the error message.

    Therefore I have to look for a different way to allow users to select their own passwords.

    Thank you,

    JFercan
    The problem is, IF the password is expired, the user cannot log on to run the stored procedure to reset their password.

    You could create a stored function that would allow a generic user to enter and update their password. You would need to add safeguards to the system to store passwords though. (look at storing the md5 hash of the users passwords so that your SF can check the md5 of the "old" password hash against the stored password hash.

    ALso, you would need to set the "generic" logon's ONLY role is to run the stored function to update the password.
    Lou
    使大吃一惊
    "Lisa, in this house, we obey the laws of thermodynamics!" - Homer Simpson
    "I have my standards. They may be low, but I have them!" - Bette Middler
    "It's a book about a Spanish guy named Manual. You should read it." - Dilbert


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •