Re: How to change users' password
From: Derrick Leggett (derrickleggett_at_yahoo.com)
Date: 12/30/04
- Next message: Alex: "Re: How to change users' password"
- Previous message: Alex: "How to change users' password"
- In reply to: Alex: "How to change users' password"
- Next in thread: Alex: "Re: How to change users' password"
- Reply: Alex: "Re: How to change users' password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Thu, 30 Dec 2004 11:24:49 -0600
>From Books Online:
sp_password
New Information - SQL Server 2000 SP3.
Adds or changes a password for a Microsoft® SQL ServerT login.
Syntax
sp_password [ [ @old = ] 'old_password' , ]
{ [ @new =] 'new_password' }
[ , [ @loginame = ] 'login' ]
You can write a script to collect all the logins into a table. Then just
use a WHILE loop to loop through the table and change all the passwords to
the same thing. Let us know if you need a script to do this.
"Alex" <Alex@discussions.microsoft.com> wrote in message
news:0BE69EBA-23CD-4038-9993-80B89439782F@microsoft.com...
> 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.
begin 666 update_topic.gif
M1TE&.#EA$@`6`/<`````````A ``_P!"0@"$A #_`$*$A(0`A(2$`(2$A(2$
M_\;&QO\``/__`/______________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M____________________________________________________________
M_____________________RP`````$@`6```(? `="!188*#!@PX*$ARH$.'"
MA \=,H384"+#!046:-RHD6&!CQ@3?E2XP$')@P4K"CQYDF!(E0IBQEP8$B+"
M!0ILAI3)<V7.@34EXC1XDJ=,GT0M(@4JT.A,DS]7*H6:U('3GT.9*LTJU:K3
3I5TM<C4Y=2S'LQRC>KUJ-" `.P``
`
end
- Next message: Alex: "Re: How to change users' password"
- Previous message: Alex: "How to change users' password"
- In reply to: Alex: "How to change users' password"
- Next in thread: Alex: "Re: How to change users' password"
- Reply: Alex: "Re: How to change users' password"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
