title: Creating a user, mapping to a database and assigning roles to that database using SQL scripts
body: <p>I've done this before but not through scripts. I've to create a new user in SQL server (SQL Authentication) and map the user to a database and assign the roles for the user to that database using SQL scripts.</p>
  
  <p>How can I do it?</p>