title: SQL Azure: list all logins and users
body: <p>I'm using <code>V12 Azure SQL</code>.</p>
  
  <p>To list all logins (<code>server level</code>) we can use this query on <code>master</code> database:</p>
  
  <pre><code>SELECT * FROM sys.sql_logins;
  </code></pre>
  
  <p>To list all users (<code>database level</code>) we can use this query <strong>on a specific database</strong>:</p>
  
  <pre><code>SELECT * FROM sys.sysusers;
  </code></pre>
  
  <p>But how to get the correspondence between <code>logins</code> and <code>users</code>? </p>
  
  <p>Where is the <code>system table</code> that stores this correspondence?</p>