Re: Sp_changepassword

what if the user doesn't remember their current password. can they do
anything?

"Erland Sommarskog" wrote:

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

.

Relevant Pages

  • Re: Grant access to applications only
    ... but to deny a direct user login e.g. via management studio. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.security)
  • Re: ALTER PARTITION FUNCTION PartFunc() MERGE RANGE & blocking
    ... I hope MS fix this livelock problem in the next service pack. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (microsoft.public.sqlserver.tools)
  • Re: IDENT_CURRENT and empty table
    ... >> And there is no definition what the result will be after fixing the bug. ... Books Online for 2005 is wrong and will be updated. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)
  • Re: sorting twice?!
    ... So I run a query to select the top 20 when ordered by datemodified ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: Rolling up spans without breaks between them
    ... CREATE TABLE periods (start datetime NOT NULL, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)