How to change users' password

From: Alex (Alex_at_discussions.microsoft.com)
Date: 12/30/04

  • Next message: Derrick Leggett: "Re: How to change users' password" 
    Date: Thu, 30 Dec 2004 08:05:03 -0800

    Hi
    I have a database that will retire, but not so soon. I need to restrict the
    access to the database that has over 400 user accounts. I want to reset the
    password of them to something, so they don't get any access, deleting
    accounts are not acceptable at this point.
    Is there anyway to change 400 users' password to same password using a
    simple query? (and of course sa and windows accounts are excluded)
    Thank you.

  • Next message: Derrick Leggett: "Re: How to change users' password"

    Relevant Pages

    • Re: Access 2003 application with MSDE backend connection error in
      ... I'm trying to create a connection using my deployed application. ... >> our internal network where the MSDE database is installed. ... >> the necessary user accounts to it. ...
      (microsoft.public.access.developers.toolkitode)
    • Re: Access 2003 application with MSDE backend connection error in
      ... > I'm trying to create a connection using my deployed application. ... >>> our internal network where the MSDE database is installed. ... >>> the necessary user accounts to it. ...
      (microsoft.public.access.developers.toolkitode)
    • Re: How to change users password
      ... use a WHILE loop to loop through the table and change all the passwords to ... > access to the database that has over 400 user accounts. ...
      (microsoft.public.sqlserver.security)
    • XP login
      ... A friend has a machine running XP. ... She already has several user accounts ... she wants to restrict when one of ...
      (uk.rec.sheds)
    • Re: Let me rephrase: Connection Timeouts on local machine ?
      ... SSEE Express Edition using User Instances if I sign in with Windows ... SQL ACCOUNTS ARE BETTER? ... Sounds like you are using a user instance instead of a regular database. ... Configuring Remote Access ...
      (microsoft.public.sqlserver.setup)