Re: Other way of Changing Password if does not have Server Role
From: Dejan Sarka (dejan_please_reply_to_newsgroups.sarka_at_avtenta.si)
Date: 09/22/03
- Next message: jobi: "Re: How can I audit the use of one sql-id"
- Previous message: Vishal Parkar: "Re: Other way of Changing Password if does not have Server Role"
- In reply to: Mark Vergara: "Other way of Changing Password if does not have Server Role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 22 Sep 2003 08:02:40 +0200
A user can change his password without being a member of the sysadmin role.
You just have to login as the user and then omit the 3rd parameter
(loginname) when using the sp_password system SP. Use just
EXEC sp_password 'old_pass', 'new_pass'
syntax.
-- Dejan Sarka, SQL Server MVP FAQ from Neil & others at: http://www.sqlserverfaq.com Please reply only to the newsgroups. PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Mark Vergara" <markvergara007@hotmail.com> wrote in message news:#SrYbVLgDHA.3024@tk2msftngp13.phx.gbl... > Hi ! > > This Mark Vergara Programmer from Comtech Solutions > > We have been creating a user login with no default server role this means > that the user we been created has no rights to do some database task, we try > to login the user we been created and try to changed the password and it > returns the error > > "Only members of the sysadmin role can use the loginame option. The password > was not changed." > > So is there any possibel way to change the password w/o setting the Server > to System Administrator or to Security Administrator > > Can you offer any advice to me? > > Thanks, > > Mark > >
- Next message: jobi: "Re: How can I audit the use of one sql-id"
- Previous message: Vishal Parkar: "Re: Other way of Changing Password if does not have Server Role"
- In reply to: Mark Vergara: "Other way of Changing Password if does not have Server Role"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
