System Functions MSSQL Tutorial

  1. Home
  2. MSSQL Tutorial
  3. System Functions
  4. How to assign a user to a database role
The syntax  for sp_AddRoleMember
sp_AddRoleMember [@rolename = ] 'database_role_name',
                 [@membername = ] 'security_account'