Okies. My mistake. After giving view database state permission to role R1, my user domain\U1 was able to check the DMV sys.dm_db_index_physical_stats but not sys.dm_db_file_space_usage. How can I find which DMVs the user domain\U1 will have access to after gettimg view database state permissions ?