title: How to check certain attributes for a USER in SQL Server
body: <p>I am trying to find the table in which I can check if a user is enabled or disabled. For example if I were to execute this command</p>
  
  <pre><code>use Database
  Go
  Revoke Connect from "DomainName\abcdef"
  </code></pre>
  
  <p>The changes are probably reflected in one of the tables, I would like to know which one. <strong>I AM <em>NOT</em></strong> interested in the change in the GUI (i.e SSMS)</p>
  
  <p>Also I would like to know whether the <strong>User Login Policies</strong> are <strong><em>enforced or not</em></strong>, by knowing which table these attributes are in.</p>
  
  <p>I have successfully found the table for a Login(server) i.e. </p>
  
  <pre><code>sys.sql_logins
  </code></pre>
  
  <p>I need to find it for a <strong>USER</strong> of a single database.</p>