title: Why am I not allowed to execute this query?
body: <p>I have a user account on a Sql Server 2008 R2 database, that is member of the <code>db_datareader</code> database role and has no further permissions. Why is this user not allowed to execute the following SELECT statement?</p>
  
  <pre><code>SELECT * FROM sys.dm_db_partition_stats
  </code></pre>
  
  <p>And which permissions do I have to set to allow him executing this query but still prevent him from doing anything harmful to the database?</p>