Re: Changing SQL Atuhthentication passwords
From: Mary Chipman (mchip@nomail.please)
Date: 03/26/03
- Next message: Loki: "Find out of object exist"
- Previous message: Tom Williams: "Re: Generating code for Application Roles."
- In reply to: Tim no more XP Allen: "Changing SQL Atuhthentication passwords"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
From: Mary Chipman <mchip@nomail.please> Date: Wed, 26 Mar 2003 15:22:03 -0500
If a SQLS user is connected, they can run sp_password without
specifying the user name argument to change their own password:
sp_password 'oldpassword', 'newpassword'
-- Mary
MCW Technologies
http://www.mcwtech.com
On Wed, 26 Mar 2003 08:04:44 -0800, "Tim no more XP Allen"
<tim.allen@torex.com> wrote:
>Hi there, I hope someone can help before I pull the rest
>of my hair out! We a have an in house app that has to
>access sql server on one of our customer sites using SQL
>authentication because they use XP and their local PC
>rights cause problems.(Long story)
>Their aplication password matches their SQL one in order
>to logon only once. However if they change their app
>password within the program, this needs to chage also in
>SQL. However i am aware only sysadmin can do this and they
>are restricted users. Is there anywork around for this?
>Either in code in the app (VB6) or elsewhere. 1 idea i had
>was:writing a stored procedure to call the system one
>(Sp_password) to change the password, as long as you have
>exec rights to the home SP ?
>
>many thanks
>Tim
- Next message: Loki: "Find out of object exist"
- Previous message: Tom Williams: "Re: Generating code for Application Roles."
- In reply to: Tim no more XP Allen: "Changing SQL Atuhthentication passwords"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
