sp_addlogin, sp_droplogin 

System Administrator or System Security Officer 

sp_adduser, sp_droplogin 

Database Owner, System Administrator, or System Security Officer 

sp_changegroup 

Database Owner, System Administrator, or System Security Officer 

sp_displayroles 

System Administrator or System Security Officer 

sp_helpuser 

None 

sp_locklogin 

System Administrator or System Security Officer 

sp_modifylogin 

Only a System Administrator can execute sp_modifylogin to change the default database. Any user can execute sp_modifylogin to change his or her own login account. 

sp_password 

Only a System Security Officer can execute sp_password to change another user’s password. Any user can execute sp_password to change his or her own password.