Changing user information

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

**Table 10-7: 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 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	sp_modifylogin	Any database
Change the group assignment of a user	System Administrator, Database Owner	sp_changegroup	User database