The following table lists the permissions needed to execute the system procedures:
System Procedure |
Permissions Required |
---|---|
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. |