Changing user information

Table 14-5 lists the system procedures you use to change passwords, default database, default language, full name, or group assignment.

**Table 14-5: System procedures for changing user information**
Task	Required role	System procedure	Database
Change your password	None	sp_password	Any database
Change another user’s password	System security officer	sp_password	Any database
Change authentication mechanism	System security officer	sp_modifylogin	Any database
Change your default database, default language, or full name	None	sp_modifylogin	Any database
Change a login account’s default database, default language, or full name	System administrator or system security officer	sp_modifylogin	Any database
Change the group assignment of a user	System administrator, database owner, or system security officer	sp_changegroup	User database