title: How To Query for Specific User Access Rights
body: <p>I have an old database that I am inheriting. The access rights are not clearly defined anywhere and I'm looking for a quick way to get them for everyone. Let's say I have a user in my database that does not belong to any membership roles. However, they have been given access to do specific things to specific tables. For example, they can run select queries on table X and run update queries on table Y. I know I can find out what they have by going to the properties for each user. I would imagine, however, that there has to be a system table somewhere that has all of this defined in it and makes it easily queryable. What would this query look like.</p>
  
  <p>FYI: I am working with SQL Server 2005</p>
  
  <p>Update: Is there also a way to do this for all databases on the server?</p>