title: create users, logins and give permissions in sql server
body: <p>i created a login : <code>bob</code></p>
  
  <p>i granted him permission to create database using : <code>sp_addsrvrolemember 'dbcreator'</code></p>
  
  <p>This automatically creates a user under the login bob, &amp; with same name as the login name. </p>
  
  <pre><code>Login - bob
  user- bob
  </code></pre>
  
  <p>Is the user created in master database?</p>
  
  <p>I executed this query : <code>select * from sysusers</code>, but i could not find any user named <code>'bob'</code> in the table. Why so?</p>
  
  <p>'bob' has the permission to create database.</p>
  
  <p>now i want to grant him permission to create table. so how do i do that?
  When i am doing it using grant, then it says cannot find user 'bob'? Why so? </p>
  
  <pre><code>grant create table to bob
  </code></pre>
  
  <p>After that, i connected sql server with login 'bob' 
  Then, i created a database : bobdb
  i entered into bobdb. 
  Now, how to give create table permission to bob in bobdb</p>
  
  <p>Do i need to add a new user?</p>