Mega Code Archive

 

Categories / MSSQL Tutorial / System Functions

 

How to assign a user to a database role

The syntax  for sp_AddRoleMember sp_AddRoleMember [@rolename = ] 'database_role_name',                  [@membername = ] 'security_account'