How user can change their password with sp_password.

From: Sang Leen (sangleen_at_hotmail.com)
Date: 08/21/03 

Date: 21 Aug 2003 07:56:22 -0700

I have a login for each user and I want that the user
can change their own password.
When the user execute sp_password get this
 "Only members of the sysadmin role can use the loginame option. "
 "The password was not changed."

They are standard user why they must be sysadmin members.

Thank you.

SL.

Relevant Pages

  • Re: Login control and restricted member pages
    ... As you said the login dialog prompts each time the page loading a image, ... protected folder. ... When a page display some images file, ... the root members folder isn't. ...
    (microsoft.public.dotnet.framework.aspnet.security)
  • Re: sp_revoke login is not working as expected.
    ... when I use DROP LOGIN and subsequently try to connect i get the folloiwng ... Since sysadmin role members are mapped to the dbo user in all databases, ... SQL Server MVP ... All of them are also a part of a windows group which has required ...
    (microsoft.public.sqlserver.security)
  • Re: Prevent Users interactive login, but allow them to run batch jobs
    ... run batch jobs but they should not be able to login to domain by pressing ... Domain Users as well as Authenticated Users are made members ... Just how you effect it so that the account meets those depends on ... Authenticated Users would still allow local login to the account. ...
    (microsoft.public.win2000.security)
  • Access problem using computer domain account
    ... All of these systems are members of a domain that I'll call DOMAIN. ... MySvr2 has a service running under the local system account. ... We've created a database login for SecGroup on all four servers. ...
    (microsoft.public.sqlserver.security)
  • Re: Restricting Access priviledge on SQL2000
    ... You must have made the "Application-Administrators" members of the sysadmin role in SQL Server. ... Take them out of the sysadmin role, add them as users in the correct database, then make them members of the db_owner role in that database. ...
    (microsoft.public.sqlserver.security)