STG Forums Index STG Forums
Seattle Technology Group Customer Discussion Forums
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Changing users' passwords

 
Post new topic   Reply to topic    STG Forums Index -> IT (Technical Topics)
View previous topic :: View next topic  
Author Message
Mike Barskey



Joined: 10 Jul 2003
Posts: 124
Location: Seattle Technology Group, Inc. (Palm Springs office)
PostPosted: Fri Jul 09, 2004 10:48 am    Post subject: Changing users' passwords Reply with quote
There are two steps to change a user's password:
  1. Change the user's password in CP
  2. Change the login's password in the backend database
You can change a user's password in CP using the Security Wizard in the Setup area.

To change a user's login password on the SQL Server, enter the following command:
Code:
sp_password 'old_password', 'new_password', 'login_name'

Replace "old_password" with the login's current password. Replace "new_password" with the login's new password. Replace "login_name" with the login name that you want to change the password for.

Note that if the old password does not exist (or if you want the new password to not exist), you must enter the word "null" without any quotes. For example:
Code:
sp_password null, 'new_password', 'login_name'
Back to top
View user's profile Send private message Send e-mail Visit poster's website MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    STG Forums Index -> IT (Technical Topics) All times are GMT - 8 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2002 phpBB Group