Changing user information

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

**Table 3-9: Commands or system procedures for changing user information f**
Task	Required role	System procedure	Master database for: alter/create/drop login/login profile commands
Change your password	User	alter login	Any database
Change another user’s password	System security officer	alter login	Any database
Change authentication mechanism	System security officer	alter login alter login profile	Any database
Change full name	System security officer	alter login	Any database
Change your own full name	User	alter login	Any database
Change default language or default database	System security officer	alter login profile alter login	Any database
Change the group assignment of a user	System administrator, database owner, or system security officer	sp_changegroup	User database
Changing a login profile	System security officer	alter login profile	Any database
Configuring a login trigger	System security officer	alter login profile	Any database