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