locked
Variable Password Expiration Time RRS feed

  • Question

  • Is there a way to make the time it takes for a password to expire variable in SQL Server?

     

    I'm working on a project that has different requirements for password expiration depending on the type of user.  For example, a normal end user logging in can follow standard system policy for expiration (30 days).  However, a system user (aka service account or application user) only needs to change once a year. 

     

    And since changing the password that application uses to login requires updating the connections managed in the application server, changing it is a pain.  So I don't want to force the app users to follow the more strict policy.  Is there a way to make the expiration variable by user?

    Friday, April 25, 2008 1:19 PM

All replies