Results 1 to 4 of 4
  1. #1
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185

    Unanswered: Force user to Change their password

    Is there a way in sql server 2000 to force users to change their passwords periodically?

  2. #2
    Join Date
    Aug 2002
    Posts
    20
    Hi,

    There is now setting you can configure to do so. But master..syslogins has a column (updatedate) so you could make a job that select every login that haven’t change their password for, let say for a, month.

    Select loginname from master..syslogins where datediff(Month,updatedate,getdate())>1


    Now you can decide if you make a cursor that change all the password (which givs you the problem too tell users) or you email them ask them to do so.

    I hope this is useful
    /Mada

  3. #3
    Join Date
    May 2002
    Location
    Timbaktu
    Posts
    185
    I think it's master.dbo.sysxlogins which contains a field named xdate2 which is basically the last time the password was changed.But the fact is that there is no other way to do this,unless you email the users about their password expiration.Sybase has a "Sysetmwide password configuration option" which was very useful in defining the serverwide password expiration dyas.

  4. #4
    Join Date
    Aug 2002
    Posts
    20
    Hi Old hand,


    If you use NT-account in your sql server you can set a expiration period in the user manager.

    /Mada

Posting Permissions

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