title: Create an new administrator level login in Azure SQL?
body: <p>I need to replace my old admin login/user with a new one. I tried the following:</p>
  
  <pre><code>CREATE LOGIN newDbAdmin WITH password='123isTheBestPasswordEver'
  CREATE USER newDbAdmin
  </code></pre>
  
  <p>With this I'm then also able to log into Azure SQL via Microsoft SQL Server Management Studio. However it doesn't seem to be an admin level login+user. I'm unable to create tables and a few other things that admins can do. I suspect I need to GRANT permissions to certain schemas (dbo?) or something along those lines ...</p>
  
  <p>So, what's the right way to create user+login on Azure SQL with the same level of privileges as the original admin (created when I create the DB via the Azure portal site).</p>
  
  <p>On a related note, I assume the proper way to dispose off the old login is:</p>
  
  <pre><code>DROP USER oldAdmin
  DROP LOGIN oldAdmin
  </code></pre>
  
  <p>?</p>