What's difference between sp_addrolemember and alter user with default schema...?
<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>