title: Difference between login and user in sql server
body: <pre><code>CREATE USER [anc] WITHOUT LOGIN WITH DEFAULT_SCHEMA=[anc]
  GO
  </code></pre>
  
  <p>what is the difference between the user and the login. </p>
  
  <p>i am not clear as to y do we create these kind of users??</p>