title: How do I generate a table of permissions granted to database tables for a database user?
body: <p>I have a SQL Server 2000 database with around a couple of hundred tables. There are several SQL user accounts that can access this database but each one has different permissions granted on tables in the DB. </p>
  
  <p>How do I create a script to give me a report of the permissions granted to a particular user. i.e. to generate something like:</p>
  
  <pre><code>Table      SELECT   DELETE   UPDATE    INSERT    ALTER
  -----      ------   ------   ------    ------    -----
  Invoices   Yes      No       Yes       Yes       No
  Orders     Yes      Yes      Yes       Yes       No
  Customers  Yes      No       Yes       Yes       No
  </code></pre>
  
  <p>and so on. It's Friday, my SQL-fu is low today and I have a million other things to do before getting finished here today and if someone had a handy script to do this already then I would be eternally grateful :)</p>