title: What's difference between sp_addrolemember and alter user with default schema...?
body: <p>Was wanting to add full access for a developer to a database. 
  I wanted them to be able to have full control over it...including deleting it if they wanted.
  Somehow I stumbled upon two ways.  Are these the right ways??</p>
  
  <ol>
  <li>What's the difference of between access/permissions between the both commands?</li>
  <li>What is the correct command to accomplish what I want?
  Thanks.</li>
  </ol>
  
  <p>Command 1  </p>
  
  <pre><code>USE [testdb1]
  GO
  ALTER USER [john] WITH DEFAULT_SCHEMA=[dbo]
  GO
  </code></pre>
  
  <p>Command 2</p>
  
  <pre><code>USE [testdb1]
  GO
  EXEC sp_addrolemember N'db_owner', N'john'
  GO
  </code></pre>