Permission to access sys.dm_db_index_usage_stats in SQL Server
===

So I have a website for internal use which tracks a bunch of stats for employees.  One of these is whether they are missing any reports.  Since the list of items that don't have reports yet only gets updated every couple days, and there is a 3 day grace period on these reports, I am comparing the Date (releaseDt) that the item was logged as missing a report to the last time the database was updated (@lastupdate).  This way, if the reports database hasn't updated but the report is complete, the website isn't ratting someone out for missing a report.

The SQL code works fine with admin level privledges, but for obvious reasons I'm not leting the ASP.NET server admin level.

I have set up a SQL account that the ASP.NET C# code uses to log in, and the permissions for everything else are fine. (read access only for the specific databases it uses.)  I can't figure out what to give it access to in order to have access to read this specific system table.

Would appreciate suggestions using either Management Studio, or using a `GRANT` SQL statement.

This appears to have related information on the table in question

sys.dm_db_index_usage_stats (Transact-SQL):
http://msdn.microsoft.com/en-us/library/ms188755.aspx
Dynamic Management Views and Functions (Transact-SQL):
http://msdn.microsoft.com/en-us/library/ms188754.aspx

    DECLARE @lastupdate datetime
         SELECT @lastupdate = last_user_update from sys.dm_db_index_usage_stats
         WHERE OBJECT_ID = OBJECT_ID('MissingReport')

    SELECT 
        COALESCE(Creator, 'Total') AS 'Creator',
        COUNT(*) AS Number, 
        '$' + CONVERT(varchar(32), SUM(Cost), 1) AS 'Cost' 
        FROM MissingReport 
        WHERE NOT( 
            [bunch of conditions that make something exempt from needing a report]
            OR
            (
                DATEDIFF(day,ReleaseDt,@lastupdate) <= 3
            )
        )
        GROUP BY Creator WITH ROLLUP

