Re: Sp_changepassword
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Tue, 11 Dec 2007 14:45:04 -0800
Jason (Jason@xxxxxxxxxxxxxxxxxxxxxxxxx) writes:
I found this sp_changepassword in BOL as non GUI way to change the
password. But my ‘test’ user won’t work because its not a sysadmin.
That is intentional.
I get Only members of the sysadmin role can use the loginame option. The
password was not changed.
However my ‘test’ user can do it via the EM GUI.
So how should users be instructed to change their password, is the EM GUI
the only option?
No, they can use sp_password.
sp_password 'oldbadpw', 'neW&muCH$Tr0nG€r'
What they cannot is to specify the the third parameter, not even with
their own username.
--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.
- Follow-Ups:
- Re: Sp_changepassword
- From: Jason
- Re: Sp_changepassword
- Prev by Date: Re: current security context is not trusted (cross db ownership ch
- Next by Date: Re: current security context is not trusted (cross db ownership ch
- Previous by thread: Re: Question about View permissions
- Next by thread: Re: Sp_changepassword
- Index(es):
Relevant Pages
|
|
