Re: sp_password

From: BP Margolin (bpmargo@attglobal.net)
Date: 08/02/02 

From: "BP Margolin" <bpmargo@attglobal.net>
Date: Fri, 2 Aug 2002 14:20:02 -0400

Austin,

Just to add to the information posted by Sue ...

Only members of the SysAdmin and SecurityAdmin roles can execute sp_password
in such a way that the passwords of other users can be changed.

-------------------------------------------
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which
can be cut and pasted into Query Analyzer is appreciated.

"Austin Henderson" <austin@firstfleetinc.NOSPAM.com> wrote in message
news:e9QuIKkOCHA.2592@tkmsftngp09...
> How can I use this command to change the password of another user.
>
> I know...
>
> sp_password 'current password','new password' for the current user but how
> do I do it for another userid? I am using osql to develop a password sync
> script and I am stuck here.
>
> Thanks
>
>

Relevant Pages

  • Re: problems sp_adduser
    ... >Members of sysadmin and securityadmin server roles can ... >execute sp_addrolemember to add a member to fixed ... database roles can ...
    (microsoft.public.sqlserver.security)
  • Re: GUI for access 2002
    ... 1.I execute a command button that loads the form with data from a members ...
    (microsoft.public.access.gettingstarted)
  • Re: SP Permission Inheritance and Table Creation
    ... > a way that limits the user from actually mimicking the application ... role so that you can execute sp_rename. ... CREATE PROC usp_PubStatic_Maintenance ... sysadmin role members or the dbo can execute the procedure. ...
    (microsoft.public.sqlserver.security)
  • Re: processadmin role
    ... Members of Processadmin role can only kill a process. ... the processes running in SQL Server, the only management option they have is ... To view the history of job, DBA can assign the execute prev on ...
    (microsoft.public.sqlserver.server)
  • Re: Transactions in ADO.Net 2 strongly-typed datsets.
    ... you need to first execute ... GroupMembers, Updates on Group members, and wrap these up by calling Deletes ... specify the transaction property to all the IUD commands. ...
    (microsoft.public.dotnet.framework.adonet)