Table 3-9 lists the system procedures you use to change passwords, default database, default language, full name, or group assignment.
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 |